Thread: How to use built-in Excel functions in PivotTable formula?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tim Davies
 
Posts: n/a
Default How to use built-in Excel functions in PivotTable formula?
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?
Reply With QuoteReply With Quote