Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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..

 

  • Anonymous's avatar
    Anonymous
    7 years ago

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

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

    • Anonymous's avatar
      Anonymous
      Not applicable

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