reset default field settings in pivotable reports

F

Forest Grove

My Excel has its default field settings for pivotable reports set as count. I
want to reset it to SUM. How can I do it?
 
P

Peo Sjoblom

You can't change the default, it is always sum as long as there are numbers,
if excel thinks it is text or if you have blanks it will change to count

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
Top