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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Default Function in Pivot Tables 1
Default values for cell formatting and Pivot tables 1
Pivot table - value field settings - default? 2
Pivot Table Default Setting 1
Pivot (Data Items "Count" vs "Sum") 2
Using text values in Pivot Tables 5
default pivot tabel from count to sum 1
pivot table data field defaults to COUNT, would like it to default toSUM 2

Back
Top