Sometimes on report level it is required to avoid “duplicate rows”.  Off course you have to avoid such kind of situations, and solve this kind of things on database level.  But sometimes you just can’t help it.  A simple work-a-round is to create a variable, with formula =max([dimension]).  It will be represented as a measure.  But more important, it will act as one.  So your duplicate row disappear.

Result – duplicate row

Capture.PNG

New Variable

Capture.PNG

Result – aggragated row

Capture.PNG

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply