You can't change the summary function for just the grand totals. You
could add another copy of the value field, as Roger suggested, and set
it to show the Average.

Or, you could add a new column in your source data, e.g. Group
Then, enter the same value for all records, such as a 1 or a space
character.
Add that field as the first field in the Row area
Set it to Subtotal by Average
Remove the Grand Totals for columns.

Arne Hegefors wrote:
Hi! I have a pivot table. In the actual table the data is shown as number of
occurences. Also the automatically created colmn and row "Total" shows the
total sum of the number of occureneces. However I wnat to show number of
occurences in the table and then the mean value at the end instead of total.
but when i try to change this the data in the table also changes. is there
any way to do this? thanks!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html