missing value in a pivot table

[Guest]

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!

 

[par_60056]

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!

Is category 3 in the dataset that the table is made from? If so, use
field settings and check "Show items with no data"

Peter

 

[Guest]

Unfortunately no, it is not in the dataset. Maybe this means I have to put
it in the dataset with no other data? I hope not. Thanks.

 

[Roger Govier]

Hi Dawn

You would have to have an entry in the source table with Category 3,
even if all other data in the row is blank.
Without it, there is no way that the PT will know that Category 3
exists.