Pivot Table summary function

E

Excel query

Is it possible to change the default summary function within a pivot table.
That is, when working with numbers, can you set the default to SUM rather
than COUNT?
 
D

Debra Dalgleish

You can't change the default settings for the data fields. If a field
contains blank cells, or cells with text, it will default to COUNT.
Otherwise, it will SUM.

To change the operation for a field, in the layout window, double-click
 
Top