If there's a blank cell in the number field, or a text entry, the data
field will default to Count, instead of Sum.

Jugglertwo wrote:
I was recently working in my pivot table and had something happened that
doesn't make a lot of sense to me so I'm asking for some assistance.
Usually, when I drag a field on to my Pivot Table in the DATA section it
defaults to the sum function with a number field. It also defaults to a count
function when I drag a field that has text in it.

Recently, I got a pivot table that default a number field to the count
function. Can anyone explain why the default has changed on this particular
Pivot Table?

Any asistance would be greatly appreciated !
Thanks!
Tim


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html