Looker Studio (not Pro) : Make a visual that uses combination filter from two data sources

[rahulmittal87]

Hi Experts, 

I am creating a dashboard which is using two data source to create various visuals and I want to make a visual that uses combination filter from two data sources. 

Dataset-1: "date", "cohort", "category", "status"

Dataset-2: "date", "cohort_set", "category", "number

here, "category" has same values between both the datasets. 

My setup :

For Dataset-1, I have three dropdown filters 

What I want to do: I want that when I

- select "dataset 1 -> cohort" in the dropdown filters (this is working)

- it updates the corresponding values in second dropdown filter "category" (this is working)

- And, it in turns uses "category" as the filter value for the Dataset-2 visual as it is common between datasets and shows the filtered data (this is not working). I am adding a simple table for dataset-2.

In this visual, the "Category" values are not used to filter out the required rows.  And, it shows random rows probably because it is looking for "cohort" filter and not "category". In my case, I want users to select "cohort" that in turn selects "category" and in turn this category value gets used to filter other data source. 

Could you please advise whether this is possible to achieve? And how. 

Many thanks in advance. 

Rahul