Pivot Table Filter Question--Need to filter for specific values

[Ulnarian]

Hi,

I am new with Pivot Tables and I have a scenario that I can't seem to make work.

Say I have the following data in a pivot table (Car Owner is in ROWS, Car Type is in both ROWS and VALUES):


Car Owner Bob's Cars:

1) Honda (100%)


Car Owner Jack's Cars:

1) Honda (33.3 %)
2) Ford (33.3 %)
3) Toyota (33.3 %)


Car Owner Emily's Cars:

1) Honda (100%)


My actual lists has 1000's or rows to review and I need a quick way to filter for any Car Owner that has ONLY Honda's (i.e. 100% value). That is, when I run the filter, it should show only Bob and Emily above.

Does anyone know how I could implement this? To get the percentages above, I have used the "Show Values as: % of Parent Row Total" in case that is helpful.

Thanks!!