[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.


"Philosopher" wrote:
It averages



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