Hello experts,

I have a pivot table and whenever I drag and drop in to the Data portion of
it, the pivot is always putting numbers in as "count" and I am always having
to change it manually to "Sum". Is there a way to change the default way that
a pivot handles info dropped into the data box. I'd like the default to "Sum"
data as opposed to "Count" it.

Thanks in advance,
Scott