Pivot Table Grand Total Average

On a pivot table, I want the grand total to be the average. When I code it, the code changes all the values in the column to an average.

if a person's % for April is 95% & the sum of all the people in the table is 1924%. If I change the grand total to average, the person's april % changes to 19% (which is an average instead of a total.

Please Login or Register  to view this content.

mmm..guess there's no answer for this....