Pivot Table Defaults

  • Thread starter Thread starter John
  • Start date Start date
J

John

Is there a way to change the default field settings Excel
assigns pivot tables? Whenever I add data, the default
is to have it be the 'count of' items. I want it to
be 'sum' with a set number format.
 
You can't change the default setting. If there are blank cells, or cells
with text, in the column, Excel will default to the Count function when
the field is added to the data area.

If each cell in the column contains a number, it should default to Sum.
 
Before you create your Pivot Table, select all the numeric part of the table of
data, do Edit / Go To / Special / Blanks, then type 0 and hit CTRL+ENTER. This
will fill in all Blanks with a 0, and your defaults should now be SUM.
 
Back
Top