| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table 'Grand Total' question, average instead of sum
Hello,
I have a list of data with three columns, these are 'Period', 'Area' and 'Cost'. I want to pivot to show the area's listed down vertically, the period horizontally across and the 'Grand Total' inserted in the pivot table to give an average of the periods instead of the sum. Is this possible? Please advise, much appreciated. Brian Taylor Manchester, England. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Grand Total | Excel Discussion (Misc queries) | |||
| Grand Average in Pivot Table? | Excel Discussion (Misc queries) | |||
| Grand total in Pivot-Table | Excel Worksheet Functions | |||
| Pivot Table -- Add column to average Grand Total | Excel Worksheet Functions | |||
| Pivot Table Calculated Field (Grand total question) | Excel Discussion (Misc queries) | |||
Threaded Mode
