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