software

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?

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

--
Regards,

Peo Sjoblom

Portland, Oregon

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