Formulas in Pivot tables

R

rob.aldridge

Hi

I would like to be able to calculate the log10 of a data field (called
B10) within a pivot chart which is set up to calculate the average
value for each set of results for B10. When I try to add a calculated
field within the pivot chart it isn't using the average value for B10
within the pivot data field - it is calculating something very
different and also adding the title "sum" to the column header for this
data field.

Does anyone now how I can calculate just the log value for each of the
averages of B10 displayed within my pivot table?

Thanks

Rob
 
Top