Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Our customer wants to see a combination of measurements for their key dimensions. These would include monthly details (pivot month) but also contain yearly averages, and other total measures. For example, here is a pivot format:
Sales for Month(Jan-Dec) Average Sales Measure 1 Measure 2 Measure 3
Region
State
District
Is there an easy solution to get the monthly Sales in a pivot and still add Average Sales, Measure 1-3 (not monthly contributions)?
Thanks.
For the measures Average Sales, Measure 1-3 you need to use AGGR() function,
for example: Average Sales might be: Avg(Aggr(Sales,Region, State, District))
For the measures Average Sales, Measure 1-3 you need to use AGGR() function,
for example: Average Sales might be: Avg(Aggr(Sales,Region, State, District))