Pivot Table Help
 

How do I change my default setting from "count" to "sum" so when I create new
pivot tables and won't have to keep changing each individual field??

Pivot Table Help
 

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.

LB wrote:
How do I change my default setting from "count" to "sum" so when I create new
pivot tables and won't have to keep changing each individual field??


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot Table Help
 

I don't think you can.

If there are any non-numeric entries in that field, excel will use Count. This
includes text and empty cells.

In fact, Debra Dalgleish shares a pivottable addin that you may want to try:
http://contextures.com/xlPivotAddIn.html

And this is from the instructions page:
http://contextures.com/xlPivotAddIn02.html#DataFields



LB wrote:

How do I change my default setting from "count" to "sum" so when I create new
pivot tables and won't have to keep changing each individual field??

--

Dave Peterson