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