This content has been marked as final.
Show 3 replies
-
1. Re: Capturing aggregated values through parameter
Matt LuttonJan 16, 2014 6:01 AM (in response to Sidharth Dash)
See if this helps. It just uses a WINDOW_AVG(SUM(Sales)) table calculation set to compute using State to get the total average across all states. Then, we can create the comparison you described. I didn't bother changing the colors, as I was pressed for time.
-
Sum Vs Average ML.twbx 1.5 MB
-
-
2. Re: Capturing aggregated values through parameter
Sidharth Dash Jan 16, 2014 6:25 AM (in response to Matt Lutton)Thanks Matt. This solved my issue.
Cheers,
Sid
-
3. Re: Capturing aggregated values through parameter
Matt LuttonJan 16, 2014 7:02 AM (in response to Sidharth Dash)
Not a problem!