Forum Discussion

TomLU123's avatar
TomLU123
Helper III
7 years ago
Solved

【Seek Help】 How to enable the Two Filter's Dropdown value based on each other?

Hi Expert,    We are building a report to show the headcount information. The report has following 4 tables.  Table 1 Active Emploee Table Employee ID Location Department 9619 Hong Kong ...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi TomLU123 ,

     

    You can create new calculated table Table_UNION, then create relationships like picture below.

     

    Table_UNION = UNION('Table 1','Table 2')

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi TomLU123 ,

 

You can create new calculated table Table_UNION, then create relationships like picture below.

 

Table_UNION = UNION('Table 1','Table 2')

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.