I have a large set of data (20,000 rows and about 100 coulmns). I wish to
select about 5 columns for a pivot "rows" and about 60 columns to place in
pivot "data". Unfortunately, when I drag these columns into "data", all of
them default to "count" of column. I then have to manually change each one to
"Sum". Is there a simple way to change this default to "sum" without a 2nd
step for each field added?