PIVOT TABLE SUM OF AVERAGES

[Philosopher]

I have a pivot table and I am trying to sum all of the averages that
are in the data section. Instead of 10.5 in the exmplae below, I am
getting the sum of all the records of data which is totalling 21 (10 +
5 + 2 + 4). Anyone know how to do this

Example:

Data

Region 1 5
Region 1 10
Region 2 2
Region 2 4

Pivot with Averages

Region 1 7.5
Region 2 3
Total 10.5

 

[Mike H.]

in Excel 2007:
I created the exact example you have and what I get looks like this:

Region 1 7.5
Region 2 3
Grand Total 5.25
The heading over the amounts is "Average of Amount".

It sounds like your Total row is not set up correctly. But not sure how you
did that.


:
It averages