Need Help of How to do a Filter

[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

 

[Herbert Seidenberg]

Excel 2007 PivotTable
With report filter.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/11_28_09.xlsx