Pivot Table summary function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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