missing value in a pivot table
On Jun 29, 6:44 pm, dawn_dudley
wrote:
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
|