Also, it might be more the calculated field for Type of Car that I need help with.
Right now I'm saying something like:
IF Trans_Type="Car" AND Engine = "5" THEN "Ford"
IF Trans_Type="Car" AND Engine = "6" THEN "Ford"
ELSE "Not Ford"
I think the problem is that the "Not Ford" is applying to all values in the Trans_Type field, when I only want it to apply to 'Car'.
It sounds like what you want in the second quick filter is the 'Only Relevant Values' to be shown. Click in the upper right corner of the quick filter and select this option from the drop down menu.
Hope this helps!