| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PIVOT TABLE SUM OF 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| weighted averages in a pivot table - how? | Excel Worksheet Functions | |||
| Pivot Table Averages at Subtotal | Excel Worksheet Functions | |||
| Pivot Table (Running averages) | Charts and Charting in Excel | |||
| Pivot table (Running Averages) | Excel Worksheet Functions | |||
| Difference between Averages in a Pivot Table | Excel Worksheet Functions | |||
Threaded Mode
