One filter, two columns

[farolito20]

Hello!

I need one country filter which work with two columns in a table.

Please see the attach file!

[anandathome]

Can you upload an example just to konw the data and expressions you are using?

I would suggest you to create a field with data from both

Buy Country and Sell Country

and then use the field in a List

[farolito20]

But, how connect the list with Buy Country and Sell Country?

[Gysbert_Wassenaar]

Add a Select in Field action to OnSelect field trigger of the field BUY ORIGIN. The field to select in would be SALE ORIGIN. The search string would be ='(' & concat(distinct chr(34) & [SALE ORIGIN] & chr(34), '|',) & ')'

When you select countries in BUY ORIGIN the same countries will be selected in SALE ORIGIN.