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?
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?
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
"Forest Grove" <Forest [email protected]> wrote in message
news:[email protected]...
> 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?
Usually the pivot table has SUM as default for numbers and COUNT as default
for text. What may happen here is that the field may contain some text, or
number formated as text, and that makes the default option to be COUNT.
To assure that this is what happens, you may create a new pivot table with
simple data in a new workbook, and check if the SUM and COUNT are assigned
appropiately. If so, then check the original column of data for text
formatted values. If not, that is beyond my expertise.
Hope this helps,
Miguel.
"Forest Grove" wrote:
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks