Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I have used a pivot table to work out and display the average/max of a set of data twice for 2 different things so i have four columns in the data part with two showing the average and another showing the max for an occurence and and two other columns doing the same for a differnt occurence. I would like to be able to add the two Average columns to have a total average and the two Max columns to have a total max. I got this to work by putting using the cells outside of the pivot table and simply adding the cells. But is there a way of doing it so it is actually part of the pivot table? It looks a little like this Ave 140 Max 140 Ave Multi Max Multi 23 25 20 20 25 25 20 20 Many thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
Pivot Table - Grand Total for selected columns only | Excel Discussion (Misc queries) | |||
Moving grand total columns in pivot table | Excel Discussion (Misc queries) |