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

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

Post by VGltIERhdm » Sun, 22 Jan 2006 12:46:01


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?
 
 
 

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

Post by Peo Sjoblo » Sun, 22 Jan 2006 13:05:26

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

--
Regards,

Peo Sjoblom

Portland, Oregon