pivot table defaults

C

cturner08

When adding numeric fields to the Values section of a pivot table, is there a
way to have the Value Field Settings default to Average rather than Sum?
Seems like a lot of clicks are required to change every field individually.
 
J

Jacob Skaria

Sorry you cannot. If there are blank cells or cells with text the default
will be COUNT; or other wise it will be SUM.
 

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

Dealing with a Pivot Table (when I don't want to) 0
Doughnut Chart linked with the slicer in the pivot table 0
Pivot Tables 0
Pivot table put multiple "Values" in one row but I want them in one column. 0
Excel 2007 Pivot Table question 1
Formula to Look up values from a pivot table 1
Slicers and Calculated Items in Pivot Table 2
Additional columns for Pivot table 0

Top