How can I change the default way pivot tables summarize by

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

Guest

By default, pivot tables summarize data by "Count". Is there a way to set the
default as "Sum", which seems to be more widely used.
 
If the data is all numeric, then you get "Sum of". If you have any non-numeric
(including spaces), you get "count of".

Maybe you could record a macro that builds the pivottable the way you like.

Or you could use a utility from Debra Dalgleish that can do this (and lots
more):
http://www.contextures.com/xlPivotAddin.html
 
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

How to set the default "summarized by" of a data field to "Sum"? 1
including zero values in a pivot table 2
pivot table to display the value instead of a summary 1
pivot table data field defaults to COUNT, would like it to default toSUM 2
Pivot Table field settings default 1
Changing Default Function in Pivot Tables 1
Excel 2003 Pivot Table Issues 3
Pivot Table Values as a % of a Subtotal 1

Back
Top