Display dropdown list values in Pivot Table

Mattie

New member
Joined
Feb 3, 2017
Messages
1
Reaction score
0
Points
0
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!
 
Last edited:
Please post a sample sheet ( go advanced - manage attachments) Thx
 
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
As @Pecoflyer said, it is preferable to attach the example files that other people would not have entered the data instead of you.

PivotTable options (see attached file)
 

Attachments

  • Mattie-navic7353.xlsx
    126 KB · Views: 15
Back
Top