Pivot Table: Summing Average Values

  • Thread starter Thread starter Tara1
  • Start date Start date
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!
 
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

multiple subtotals in pivot table 1
Can i hide parts of a Pivot tables subtotals??? 2
Average of % in pivot table 1
Average of Subtotals in Pivot Table 0
Pivot Table Formula Problem 1
Conditional SUBTOTAL in XL210 Table 7
Pivot Table % Variances 0
PIVOT TABLE SUM OF AVERAGES 1

Back
Top