How to set the default "summarized by" of a data field to "Sum"?

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

Guest

When making pivot table, it's very common that when a data field is dragged
into the table, it is defaulted to be summarized by Count, while in most
cases, it's a Sum that we need. Is that a way to set "Sum" as a default?
 
Nope.

Excel will use sum if all the entries in that field are numeric.

If any are blank or text, you'll get Count.
 
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

Pivot Table field settings default 1
How can I change the default way pivot tables summarize by 1
pivot table data field defaults to COUNT, would like it to default toSUM 2
Create Pivot Table Data with Column "Sum" rather than "count" defa 2
Pivot table - value field settings - default? 2
Changing Default Function in Pivot Tables 1
Summing data by month 5
Unable to change field settings in calculated field in a pivot tab 1

Back
Top