Sum of Average

[#1]

I need to show the sum of average in a pivot table:

Office	Total Sum(Prom SalesMonth)	Prom Month 1 Avg(SalesMonth 1)	Prom Month 2 Avg(SalesMonth 2)	Prom Month 3 Avg(SalesMonth 3)	Prom Month 4 Avg(SalesMonth 4)
Office 1	32	3	7	18	4
Office 2	47	14	5	16	12
Office 3	49	20	7	13	9
Office 4	22	10	1	2	9
Office 5	55	17	13	11	14
Office 6	39	6	5	16	12

But instead is calculated the average of the averages. Help please. Thanks.

[maxgro · Accepted solution]

try

sum(aggr(avg(Sales),Office,Month))

[#3]

Massimo, thank you very much.