I'm having trouble creating the pivot table I want because some of the items in the list are classified into multiple categories, or "Industries." The current way I have things set up in the spreadsheet, Sheet 1, is that under my "Industry" column, Product Names are sorted into categories like "Food" or "Retail." However, some of these items have multiple categories, so I have formatted them as "Food, Retail." When I go to the pivot table mode on Sheet 4, and I use the "Industry" drop down in Report Filter, things are showing up as "Food, Retail" but I want to try to format it in such a way that there are only single categories are displayed. Products that fall into 2 different industries like the "Food, Retail" example should show up if I choose "Food" or "Retail" and there should no longer be a "Food, Retail" category.

On a separate note, my spreadsheet contains "Product Types" and their subset "Product Specifics." In the Pivot Table mode, is there a way to only show Product Type first, so that users can select a Product Type like "Dairy" for example. Then, they will be allowed to search the "Product Specifics" subset like "Cheese."

Thank you very much!

The file:
Experimental Data Template.xlsx