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....