Thu 18 Jan 2007, 11:29Delegate Paul said...
Paul has attended:
Excel Advanced course
Pivot Table Deafults
My totals within my pivot tables are defaulting to "Count" rather than "Sum". Can I change the defaults anywhere?
Thu 18 Jan 2007, 11:56Trainer Richard said...
RE: Pivot Table Deafults
If you drop a non-numerical field into the Data area on a pivot table, it will default to COUNT. If the field is numerical, then the default is SUM.
Click on "field settings" to modify the function.
