How to use built-in Excel functions in PivotTable formula?

T

Tim Davies

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?
 
P

Peo Sjoblom

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

--
Regards,

Peo Sjoblom

Portland, Oregon
 
Top