Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table -- Add column to average Grand Total
I have a pivot that someone wants to get the average of the Grand total
within her pivot table. I'm having problems with this as when I add a column and put in a formula it changes the data in the whole pivot table. Can I add a column and get the average of the grand total without changing the data in the pivot table itself? Appreciate any suggestions!! |
#2
|
|||
|
|||
Here is how the data is set up:
Pay type OT Sum of FTE Act Fiscal Period Center Jan Feb Mar Apr May Jun Jul Grand Total 11513013 3.12 3.36 3.43 2.85 1.68 1.69 1.54 17.67 11513014 - 0.02 0.13 0.02 0.07 0.11 0.10 0.45 11513017 0.67 2.00 1.25 0.68 0.53 0.87 1.24 7.24 "Lynn" wrote: I have a pivot that someone wants to get the average of the Grand total within her pivot table. I'm having problems with this as when I add a column and put in a formula it changes the data in the whole pivot table. Can I add a column and get the average of the grand total without changing the data in the pivot table itself? Appreciate any suggestions!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Stripping time in Pivot Table Column Header | Excel Worksheet Functions | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
pivot table results - with value in every row and column | Excel Discussion (Misc queries) |