View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pelham
 
Posts: n/a
Default Calculated Fields in Pivot Tables

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?