Pivot Table counts instead of data

[BobS9895]

I have a worksheet that has one column with weights. Whenever I run
the pivot table, the table has a "count" of the number of weights,
rather than the actual weights themselves. How do I correct this?

 

[aidan.heritage]

Put the weights in the left hand side of the pivot table, not the
middle of it - they are then row labels.

 

[BobS9895]

LOL, that kind of defeats the purpose of what I'm doing! But thanks
anyway.

 

[Debra Dalgleish]

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]

Thanks Debra, got it!