Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table: Summing Average Values
I am doing a pivot table where the values are displayed as averages. The
subtotal line is then taking the average of all of the rows. I would like for the subtotal to be the sum of all of the rows but cannot figure out how to do it. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table: Summing Average Values
Unfortunately, you can't change the subtotal so it sums all the
averages. You could do the calculation in a column outside the pivot table. Tara1 wrote: I am doing a pivot table where the values are displayed as averages. The subtotal line is then taking the average of all of the rows. I would like for the subtotal to be the sum of all of the rows but cannot figure out how to do it. Thanks! -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table: Summing Average Values
Excel 2007
Two ways to do average of average: Add helper columns to PT source, or filter a modified Table. http://www.mediafire.com/file/dteg3qzyr3m/12_13_08.xlsx |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table: Summing Average Values
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table: Summing Average Values
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing Problem In A Pivot Table | Excel Worksheet Functions | |||
Pivot Table not summing | Excel Discussion (Misc queries) | |||
Summing values in a table | Excel Discussion (Misc queries) | |||
pivot table column summing | Excel Discussion (Misc queries) | |||
Exclude zero values using average function in a pivot table | Excel Discussion (Misc queries) |