Forum Discussion
Can I show a count of 0 in a pivot table
Let's assume my data is like this: Category Details Pens Super Pens Mediocre Pencils Pivot will show Pens 2 Pencils 1 I need to show Pencils ...
nilanprospecta Be sure that you are counting Details in the value field and that the cells that appear to be empty really are empty. A cell with a single space may look like a blank, but it will be included in a count as 1, just like you experienced it.