How to Get Sum of the Average in Pivot Table?

G

Guest

Help! I have a Pivot Table that calculated the inventory in average.
However, on the total row, I'd like to get the sum of the average. How to do
that? Thank you.
 
P

Peo Sjoblom

You already got an answer to your earlier post

"You can remove the grand total from the table options and replace it with a

=SUM(Range)

AFAIK there is no way of having grand total using sum while the rest is
average"

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 

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

Pivot Table 3
Average of % in pivot table 1
Pivot table Average with [h]:mm format 5
Average of Subtotals in Pivot Table 0
Pivot Table Calculating totals differently 1
Pivot table average 1
Excel 2007 Pivot Table question 1
Formulas in Pivot Table 4

Top