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