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!

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

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

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

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