Quick pivot table question

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

Guest

This one is much simpler. Whenever i create pivot tables (and i create a lot)
I want to work with the Sum function 99% of the time. However, it always
defaults to 'Count'. then, when I change the field settings it forces me to
do each one individually. So, my question is one, can you set it so it
defaults to sum? Or two, can you do a multiple line field setting change?
Thanks again.
 
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.

There's a feature that changes all the data fields to SUM, in the pivot
table add-in that you can download here:

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

Pivot table questions 1
Changing Default Function in Pivot Tables 1
Pivot Table Help 2
pivot table defaults 2
default pivot tabel from count to sum 1
Excel 2007 Pivot Table question 1
Pivot table - value field settings - default? 2
One pivot table for multiple worksheets/tabs 2

Back
Top