8 Replies Latest reply on Apr 12, 2018 6:57 PM by Mike Mainzer

    Having Multiple dimensions in LOD shows wrong aggregated value

    Gurpreet Singh Goraya

      Hi All,

       

      I am trying to get an aggregated measure based on two dimensions. I noticed that the aggregated value is little off than the actual values. Here is the screenshot of individual dimensions.

      I created the following LOD based on these two dimensions.

      { Fixed    [PICKUPADDRESSNAME],[DROPOFFADDRESSNAME],[Date]:COUNTD([BOOKINGID])}

       

      I noticed that aggregated value is different than the actual. The following screenshot shows the result with LOD:

       

      I also want to let you know that I put filters in Context and used "INCLUDE" operator in the LOD. But, all vain. Please advise. Thanks