Looker Studio Filter

[Samuel_W]

I have 3 google sheet data sources, the first two have data for individual departments and the third lists those departments with rollup categories like "Division"

I want to build a blended data sources which will allow me to filter all of the data by "Division"

Essentially I want Looker Studio to lookup which departments belong to that division and filter the report to those department

[Looker_Studio_B]

Start with this, and then adjust for your case:

How to build a control that filters blended data in Looker Studio? | Medium