What does your data structure look like? Can you post a subset of randomized records in an Excel file, pull that into Tableau as an extract, and post the packaged workbook here in the thread? This will help ensure you get the best feedback possible from this forum. A lot depends on how your data is structured, though, and its not clear from your description. Cheers
Off the top of my head, a simple calculation like:
IF NOT CONTAINS([Product], "C") then [OrderNumber] end
Placed on the filter shelf would remove any order numbers that do not contain Product C. But again, any solution will be dependent on your data structure/source.