Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel software training - Pivot Table Deafults

excel software training - Pivot Table Deafults

ResolvedVersion Standard

Thu 18 Jan 2007, 11:29 Delegate 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:56 Trainer 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.

Thu 18 Jan 2007, 11:58 Delegate Paul said...

RE: Pivot Table Deafults

The fields in question are "Sales" and "Targets" and therefore numerical. I have managed to change them on the field settings.

Training courses

98.3 % recommend us

More live stats...

Training information:

Excel tip:

Highlighting only Text cells

To select onlt text value cells in a spreadsheet, click on Edit-Go to(F5)

In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

View all Excel hints and tips