A calculated field in subtotals and total will always be SUM.

--
Regards,

Peo Sjoblom

Portland, Oregon




"Tim Davies" wrote in message
...
I am trying to use the formula: =MAX('Operating Hours')/Count in a
pivotTable
formula, but Excel always returns the sum of the operating hours field and
not the max value. Does Excel have the ability to use the built-in
functions
within pivotTables? If so, can someone tell me how to use them?