I am using a Pivot Table to get a sum of how many are in each category.
Categories are 1, 2, 3 4 or 5. Sometimes I have none in a category.
Is there any way to show a pivot table show all 5 categories if one of them
has
no one in the population without adding a blank line with the category? I
invariably get (say category 3 is blank)
Category Sum
1 10
2 12
4 50
5 3

Ideally, I would like to see category 3 with 0 or even blank.

Thanks so much!