missing value in a pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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!
Click to expand...

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
 
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.
 
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.
 
Back
Top