Excel - Pivot Table default Value Field Settings

Asked By Max Scott on 29-Sep-09 07:07 AM
Hi

I use pivot tables a lot and the vast majoirty of the time I use it to sum
data. Excel defaults the Value Field Setting to Count so I have to change it
every time. Is there any way I can change the default to Sum?

Thanks




Dave Peterson replied on 29-Sep-09 08:08 AM
If all the data in the field is numeric, then you will see Sum.

If any of the data in the field is text (or empty!), then you will see Count.

I do not think you can change this behavior.

But you can use Debra Dalgleish's pivottable addin to lots of stuff:
http://contextures.com/xlPivotAddIn.html



--

Dave Peterson