Cross Tab/Pivot with Additional Measurements?

[#1]

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.

[Anonymous · Accepted solution]

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))