You can't change the summary function for a calculated field. Perhaps
you can do the calculation in the source data, and add that field to the
pivot table.

Pelham wrote:
I have just used the Calculated Field function in a Pivot Table in
order to give me the value of one field divided by another field.
Although I have the new Calculated Field in my Pivot Table it assumes
that I want the Sum of this field, but I actually want the Average
instead...

How can I get averages instead of sums?



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