Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Filter not showing what expected

Hello all. I have two tables and one filter. The first table shows information about product value for every year and the second table shows countries that exported selected products from the first t...
Need Help
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

To get matched values when make filters, you may make sure the Cross filter direction of the two tables is Both instead of Single, which will take the two tables treated as a single table.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
6 years ago
Amy ( v-xicai ) is right - a cross filter direction of both can help with filtering and treating two tables as one, but I do not recommend this solution for a 1 to many relationship.

Please Anonymous can you share more details about your data model relationships so we can target our solutions, ideas and advice better?