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

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding formula to PivotTable 1
Pivot Table Problems 3
PivotTable/Chart - Statistics (Excel 2007) 1
Changing summary options in PivotTables 1
Excel 2007 - Pivottable formula with COUNT 2
Pivot Table from linked spreadsheets 1
date series in PivotTables 4
Function to return a range of cells from a PivotTable 2

Top