Pivot Table counts instead of data

B

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?
 
A

aidan.heritage

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

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
 
Top