I am counting inventory in a pivot table. I want the item to show in the
Column, but I do not want an empty cell to show in the counts, which it does
now.

How do I prevent empty cells from counting, but show the item itself?

Thanks

Dave