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€¦.
|