Forum Discussion
Dynamically filter other tables in model
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..
- Anonymous7 years ago
Please can you share a snap of first few rows of your tables to better understand your case.
2 Replies
- AnonymousNot applicable
Please can you share a snap of first few rows of your tables to better understand your case.
- AnonymousNot applicable
Thanks Raj managed to solve the issue it was a relationship issue.