Pivot Table Field Settings

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

Guest

Is there a way to change the default in the field settings or change multiple
lines at once from "count" to "sum"?

Thanks,

Cindy
 
Hi Cindy

Jim is quite right, there is no inbuilt feature to do this.
But, Debra Dalgleish has a nice add-in on her site which allows you to do
many things with the Pivot Table, including changing all data fields to the
selected summary function.

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 default Value Field Settings 1
Pivot table calculated field Count(field) / sum(field) 0
pivot table calculated field 1
Pivot Table default field setting 2
Pivot captions and VBA to sum instead of count 1
Changing Pivot table defaults 4
Pivot Table question: Creating a new field that calculates thedivision of one data field by another 4
Calculated Field in Pivot Table minimum value 0

Back
Top