How to Get Sum of the Average in Pivot Table?

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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

Average of % in pivot table 1
Pivot Table 3
PIVOT TABLE SUM OF AVERAGES 1
Pivot Table: Summing Average Values 4
How to set default calculation method in pivot tables? 2
Average of Subtotals in Pivot Table 0
Pivot table Average with [h]:mm format 5
Pivot table average 1

Back
Top