how to filter a pivot table using a separate filter

[FrancisM2411]

Hi There,

I have a list of data and I have created a pivot table with all necessary data i need in it. instead of using the filter in the pivot table I want to link to an existing drop down menu I have on a separate sheet so that the data updates accordingly with the other sets of data. my main aim is to use the data that gets updated to creat a dynamic graph. In my attachment you can see Cluster and Industry, so when I connect the pivot to a separate cluster dropdown menu,it'll create a graph for all the industry under that Cluster.