Default pivot table function

[Mike Boardman]

Is there any way of having the default pivot table function come up as SUM
rather than COUNT?

I use them a lot, and it gets annoying to have to change it 99% of the time!

TIA

 

[Frank Kabel]

Hi
AFAIK you can't change this

 

[Mike Boardman]

Frank

Thanks for that - I had a horrible feeling it might not be the case! It does
rather beg the question "Why is SUM the first function listed but Count is
the default?!!!"

Ahj well, not to worry - life's too short to ponder the mysteries of
Microsoft's ways!

Mike

 

[Debra Dalgleish]

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.

 

[Mike Boardman]

Debra

Thanks a lot -that explains it! We often have blank cells in the data, so
we'll have to see if we can eliminate them.

Mike

 

[Ken Wright]

As long as you can live with what was blank being 0, then select the entire
table, do Edit / Go To / Special / Blanks, type 0 then CTRL+ENTER and it will
populate all blanks with 0. Your data will now all default to SUM.

 

[Mike Boardman]

Thanks Ken - an interesting option which I'll keep in mind.

Mike