Pivot Table: Summing Average Values

T

Tara1

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!
 
D

Debra Dalgleish

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of % in pivot table 1
Average of Subtotals in Pivot Table 0
Pivot Table Formula Problem 1
Conditional SUBTOTAL in XL210 Table 7
Can i hide parts of a Pivot tables subtotals??? 2
Pivot Table percentages 1
Excel 2007 Pivot Table question 1
Pivot Table Average Problem 2

Top