Filter by multiple criteria

[GregStewartPTC]

I am trying to find an easy way to allow an end user to filter a pivot table by multiple criteria, only if both are met. Example workbook with redacted info is attached - I have the data available arranged in a few different ways to work with. The end goal of the user is to be able to filter to show customers with a combination of products, but not to display if they don't meet all criteria. For example I want to know everyone who has products 1 2 and 3, but do not want them to be listed if they are missing any of the 1 2 or 3. The example data set is small, but the actual data contains about 10,000 customers and 500+ products. The end user only has a surface level understanding of excel, so I'm trying to make the output as simple as possible for them.

Any help at all would be greatly appreciated. Thank you.

[JeteMc]

Perhaps something like the following:
1. Another column is added to the data on the Table1 sheet using: =SUMPRODUCT(COUNTIFS(B$2:B$17,B2,D$2:D$17,G$1:K$1))=COUNTA(G$1:K$1)
2. The end user would select the products to be included in cells G1:K1 on the Table1 sheet
3. The pivot table (Table2 sheet) would use the results of the additional column in the Filters ara to display only the customers with the selected combination of products when the end user selects TRUE
Let us know if you have any questions.

[GregStewartPTC]

Thank you that's a great solution! Marking solved.

Have a great day

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.