Default value is 'count'; why?????

[mgville]

I rarely use count in my pivot tables, is there a setting I can change in
excel so that when I select my values, which is usually 5 or more, I have to
reset to sum instead of count.

It's extremely time consuming and very frustrating.

Any suggestions?

 

[Jacob Skaria]

You cannot change the default settings. Check out the below link by Debra
Dalgleish for Add-In

Search for "Can I change the default summary function for data from COUNT to
SUM"

http://contextures.com/xlfaqPivot.html#DefaultSUM

If this post helps click Yes

 

[mgville]

Thanks Jacob.

I did find something else for Excel 2007.

Create your pivot table, select the values you want, click on the tool bar
and select 'Add-Ins'. Select the option called 'PIVOT', select 'Data
Fields...', SUM All Data.

Misty

 

[Jacob Skaria]

Thanks for posting this..Im currently using Office 2003. Will definitely try
this in '07...

 

[Jaleel]

Field Settings is possible in Office 2003 too. We can switch between many
options in Field Settings.

Jaleel