Dynamically filter other tables in model

[Anonymous]

Hi Experts

Is it possible to do the following. I have taken column trend from my FACT table (table A) and added this as filter to my report. Everything is fine. Tables B, C, D and E have the same columns "trend" all tables can be linked together using a common column Co.ID. 

Hear goes how can I dynamically point my filter to the right table based on what filter I am using, so if I select manufacturing filter I want to use trend column from table B as my filter in my report as opposed to table A trend column. And

If I select country I want to use trend column from table C as my filter in my report. And so on..

[Anonymous · Accepted solution]

Please can you share a snap of first few rows of your tables to better understand your case.

[Anonymous]

Thanks Raj managed to solve the issue it was a relationship issue.