Skip to Content
Author's profile photo Koen Hesters
Koen Hesters
May 8, 2014 Less than a 1 minute read

Aggregated Dimension

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

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Alexander Batista
      Alexander Batista

      I'm trying to view the date when an order was modified and to what to it was modified to. However, when I create a query the Effective Date & Time + Detail Display Value repeat multiple times per time. The only option that shows me the correct sequence is Action Sequence, but I cannot add the Effective Time and Date. If I use MAX it only shows me the largest value, but not the values corresponding to what date and time.