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!

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

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

Pivot Table: Summing Average Values
 

New, improved, with chart:
http://www.mediafire.com/file/zyfnztnzmmm/12_13_08.xlsx

Pivot Table: Summing Average Values
 

Yet more improvements:
Simple formulas:
http://www.mediafire.com/file/ygzdi1k3klx/12_13_08.xlsx