software

I have a worksheet that has one column with weights. Whenever I run
the pivot table, the table has a quot;countquot; of the number of weights,
rather than the actual weights themselves. How do I correct this?Put the weights in the left hand side of the pivot table, not the
middle of it - they are then row labels.LOL, that kind of defeats the purpose of what I'm doing! But thanks
anyway.If a field contains blank cells, or cells with text, it will default
to COUNT. Otherwise, it will SUM.

To change the function after adding the field:
Right-click on a cell in the Weights column, and choose Field Settings
From the Summarize by list, choose Sum, and click OK
BobS9895 wrote:
gt; I have a worksheet that has one column with weights. Whenever I run
gt; the pivot table, the table has a quot;countquot; of the number of weights,
gt; rather than the actual weights themselves. How do I correct this?
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.htmlThanks Debra, got it!