Excel 2007 : [Solved] Pivot Table Drill Down

[sdgenxr]

I hope I can explain this adequately, so here goes.

I have a large table with a column for Makes, and one for Models with each make having multiple models, but each model having only one make. One to may relationship. What I would like to do on my pivot table is have the report filter for the Make then only show the Models that have that make and none other.

Any ideas?

TIA