Skip to Content
0
Jun 15, 2018 at 03:01 PM

How to return overall average?

54 Views

I have data that is set to Aggregate by average. I now want to show the delta for 3 Dimensions to the overall average. I can create a measure that is the average(measure) but this value is not the overall average. It is the average of averages.

There are 9 Level 2 Dimensions not shown. This makes the Ave(measure) <> Average(overall).

Is there a way to get the overall result so I can then calc the delta by lvl1?

I cannot find a syntax that can do this.

Attachments

capture.png (8.0 kB)