Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add AVERAGE column to Pivot Table
I have a pivot table with sales reps for rows and months for columns. The
data is the sum (total sales) for each rep. I have Grand Totals turned on for both columns and rows. However, I would like to see Total Sum for the column grand totals and Total Average for the row grand totals (an average of the 12 months). How do I do this? If I go into field settings on my (total sales) data item and change it to average, both column and row grand totals change. How can I configure them independently? [Excel 2003] Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average of % in pivot table | Excel Discussion (Misc queries) | |||
Average in a Pivot Table | Excel Discussion (Misc queries) | |||
Pivot table, average of nex column | Excel Discussion (Misc queries) | |||
Pivot table, add new column for average | Excel Discussion (Misc queries) | |||
Pivot Table -- Add column to average Grand Total | Excel Worksheet Functions |