Need Help of How to do a Filter

  • Thread starter Thread starter SanCarlosCyclist
  • Start date Start date
S

SanCarlosCyclist

I am having problems conceptualizing how I can do a specific filtering
of a pivot table. Below is a sample pivot table that has various
colors assigned to each case number. I want to be able to filter this
pivot so that it only shows full records that contain Green.

Here is the initial pivot:

Case# Color
1 Red
1 Blue
1 Green

2 Yellow
2 Blue

3 Green
3 Yellow

4 Blue
4 Yellow


Here is my desired result (Cases that contain Green):
Case# Color
1 Red
1 Blue
1 Green

3 Green
3 Yellow

Could someone please advise me of how I might accomplish this. Thanks
much
 
Back
Top