Hello all,
I need help with a very simple task but I dont seem to find the right help anywhere.
I want to show in a pivot table how many items are in a certain status. Let say that possible statuses go from A to E, listed in a dropdown in the source data. How can I show all the possible options in the pivot table so that if there are 0 items in a status it is also shown?
Example:
ITEM____STATUS
Item 1___A
Item 2___A
Item 3___B
Item 4___C
I want to see int he pivot table:
STATUS__COUNT
A______2
B______1
C______1
D______0
E______0
The issue is that I cannot now see the values 0 for D and E. I am sure there is a very easy way of doing it
Thanks!
I need help with a very simple task but I dont seem to find the right help anywhere.
I want to show in a pivot table how many items are in a certain status. Let say that possible statuses go from A to E, listed in a dropdown in the source data. How can I show all the possible options in the pivot table so that if there are 0 items in a status it is also shown?
Example:
ITEM____STATUS
Item 1___A
Item 2___A
Item 3___B
Item 4___C
I want to see int he pivot table:
STATUS__COUNT
A______2
B______1
C______1
D______0
E______0
The issue is that I cannot now see the values 0 for D and E. I am sure there is a very easy way of doing it
Thanks!
Last edited: