How to Get Sum of the Average in Pivot Table?

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)



"Evanya" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>

I know this is an old thread, but I came up with a work around for Summing up the Averages. It is not the best solution, but it does the trick.

Please Login or Register  to view this content.

good day
Attachment 702968
please help me above problem i want to get sum of Average