We are running Excel 2003. We have a simple pivot that containing 2 row
items (Category and Subcategory; totals on Category only), it has one
column item (Month) and one data area item (AMOUNT, which is summed)
Grand Totals are turned on for rows, not columns. Its prettty basic.
The user wants to add an average alongside the Grand Total row however
they don't want to see the average with each month. Is there a way to
do this. As soon as I drop AMOUNT into the data area for a second time
and double click it and set it to: AVERAGE and click OK, I get the
averageAMOUNT alongside the SumAMOUNT in each month and alonside the
grand total at the end. They only want it alongside the grand total
though.

By the way, I can not hjust hide the columns because another sheet
actually links to the pivot (the pivot is protected and
frozen)...anyway if I allow the extra columns to appear I must then
alter many, many links in the referencing sheet. To further elaborate,
the pivot acts as data for a prettied up, complex report on another
tab....


--
bobf
------------------------------------------------------------------------
bobf's Profile: http://www.excelforum.com/member.php...o&userid=34094
View this thread: http://www.excelforum.com/showthread...hreadid=538618