Forum Discussion

Bambroo69's avatar
Bambroo69
Frequent Visitor
3 years ago
Solved

FILTER FLOW

Here I have created two tables, Supplier Table(Dimension Table) and Material Table(Fact Table). Based on the filter flow the filter are flowing downwards. If I try to filter number of vendors per SP...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    3 years ago

    Hello Bambroo69 ,

     

    true, the arrow direction determines which table filters the other table, so if you got a field from a table that's against the flow then it won't filter it.

     

    what you should do is use all the fields that you want to see the values with from the dimension tables and the values from the fact table.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin

Idrissshatila's avatar
Idrissshatila
Super User
3 years ago

Hello Bambroo69 ,

 

true, the arrow direction determines which table filters the other table, so if you got a field from a table that's against the flow then it won't filter it.

 

what you should do is use all the fields that you want to see the values with from the dimension tables and the values from the fact table.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin