Board index MS EXCEL

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

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

 
 
 
Top

1. Excel add-ins does not show up in Excel>Tools>Add-ins list.

2. Can I get native code add-ins when I development the add-ins using C#?

3. Excel add-ins not loaded using New Excel.Application in VB.Net

4. Disabling Add-Ins, plug ins

5. Schedule an email without plug-ins or add-ins?

6. Problem migrating VS2003 add-ins to VS2005 add-ins

7. Remap Copy (CTRL+INS) Paste (SHIFT+INS) to other keysyms

8. XP SP2 active x control,add-ins,plug-ins nightmare

9. Solver in add-ins folder, but not in add-ins under tools menu

10. Microsoft Access 2000 - Why are the add-ins greyed out after ins

11. Com add-ins versus normal add-ins?

12. WIN XP SP2 active X controls, plug ins, add ins, downloading s

13. Ins PA w/Life Ins sw such as Cyberlife, Vantage, Life70, etc. Contract to Hire Perm

14. Visio Tools? Add-Ins, Plug-Ins, etc.

15. WIN XP SP2 active X controls, plug ins, add ins, downloading software

All times are UTC
Board index