Pivot Table default field setting

[BK]

Working on Excel 2003

Machine One: When dragging fields to the data section of a pivot table, the
default function is "sum."

Machine Two: When dragging fields to the data section of a pivot table, the
default function is "count."

Question: Is there a way to set the default function of the field setting
prior to creating the pivot table?

Another question: Is there a way to globally change the field setting after
dragging all to the data section? I am comparing monthly data, so I have 12
fields that I drag to the data section (Jan, Feb, Mar, etc) As of now, I am
changing them one at a time from "count" to "sum" but there has to be an
easier solution.

Any help???

 

[Dave Peterson]

The default depends on the field that you drag to the data area.

If all the cells are numeric, then you'll see "Sum of". If any of the cells
contain text or are empty, then you'll see "Count of".

I don't know of anyway of changing the default, but Debra Dalgleish has an addin
that offers lots of features--including changing this data field summary
function:

http://contextures.com/xlPivotAddIn.html
and
http://contextures.com/xlPivotAddIn02.html

 

[BK]

It's helpful to know the reason that "count" is the function if any cells in
the data range are blank. Thanks.