Pivot Table Repeating Values When i Want the Sum of Them

[Atlas87]

I have a spreadsheet which has some single columns of numbers which i want to pivot (rather than using COUNT) to show occurrences of entries.

But the pivot table is just repeating the values. I am dropping the column header into ROW and VALUE. The point is also that i know for example that there are two or three occurrences of the zero entry so my guess was that the right hand column would reflect that.

[TABLE="width: 720"]
<tbody>[TR]
[TD]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD]35[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD]43[/TD]
[TD="align: right"]43[/TD]
[/TR]
[TR]
[TD]61[/TD]
[TD="align: right"]61[/TD]
[/TR]
[TR]
[TD]62[/TD]
[TD="align: right"]62[/TD]
[/TR]
[TR]
[TD]64[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]67[/TD]
[TD="align: right"]67[/TD]
[/TR]
[TR]
[TD]70[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD]72[/TD]
[TD="align: right"]72[/TD]
[/TR]
[TR]
[TD]79[/TD]
[TD="align: right"]79[/TD]
[/TR]
[TR]
[TD]95[/TD]
[TD="align: right"]95[/TD]
[/TR]
[TR]
[TD]129[/TD]
[TD="align: right"]129[/TD]
[/TR]
[TR]
[TD]150[/TD]
[TD="align: right"]150[/TD]
[/TR]
[TR]
[TD]270[/TD]
[TD="align: right"]270[/TD]
[/TR]
[TR]
[TD]330[/TD]
[TD="align: right"]330[/TD]
[/TR]
[TR]
[TD]661[/TD]
[TD="align: right"]661[/TD]
[/TR]
[TR]
[TD]668[/TD]
[TD="align: right"]668[/TD]
[/TR]
[TR]
[TD]801[/TD]
[TD="align: right"]801[/TD]
[/TR]
[TR]
[TD]1061[/TD]
[TD="align: right"]1061[/TD]
[/TR]
[TR]
[TD]1290[/TD]
[TD="align: right"]1290[/TD]
[/TR]
[TR]
[TD]2136[/TD]
[TD="align: right"]2136[/TD]
[/TR]
[TR]
[TD]4360[/TD]
[TD="align: right"]4360[/TD]
[/TR]
</tbody>[/TABLE]

Whats going on here.....?

 

[RoryA]

I'd guess your value field is not set to Count.