Excel pivot table doesn't show duplicate entries?

Hello Excel chiefs,

I have this problem with Excel 2010. I'm hoping you might help me out.

I'm building an inventory database for metals.
I'm trying to make an overview of all our metals, or what's left of them after cutting.

Unfortunately, the pivot table I've made doesn't show duplicate entries. Lots of them are duplicate however (e.g. 650).

Any ideas to reveal those darned duplicates, or maybe an alternative for showing all diameters with their corresponding lengths as in the picture?


*lengte = length, over = what's left after cutting (yeah, I'm Dutch).


Thanks!


Edit: I figured it out. Well, not entirely but I put an extra column in that states how many times a specific entry does show up.

Thanks for considering my request!

http://postimg.org/image/qvf2ci58t/

Either add values field with count of given type (probably best solutuion, because you seem to use just two column fields no value field in your pivot table) or do not use pivot table at all, but just excel table (Ctrl+T).