Pivot Table Sum vs Count
 

When dragging items into the Data field of the Pivot Table Layout wizard, I
have to double click on each item to change €œcount€� to €œsum€�. I have data
for 40-50 field buttons to add and Id like to know if there is a simple step
to change all these fields to €œsum€� rather than double-clicking on each one
individually.

Ive noticed that sometime when I drag fields into the Data field, itll
automatically Sum vs. Count. Not sure what causes this€¦.