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 - 15 Nov 2006 14:44 GMT
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
> Working on Excel 2003
>
[quoted text clipped - 14 lines]
>
> Any help???

Signature
Dave Peterson
BK - 15 Nov 2006 22:22 GMT
It's helpful to know the reason that "count" is the function if any cells in
the data range are blank. Thanks.
> The default depends on the field that you drag to the data area.
>
[quoted text clipped - 35 lines]
>>
>> Any help???