Hi, Thanks for responding, let me try to explain it clearly, Refer to the below table on how my data look like Currency Amount Card Brand JPY 100 XXX CNY 100 XYZ INR 100 UUU 1. I should have a dropdown name currency and list down 2 options, one will be Local (assume JPY is local here currency in this case), second option will be cross border 2. When i choose Local, then i need to show the result where the currency = JPY (this is straight forward one) Currency Amount Card Brand JPY 100 XXX 3. When i choose cross border, then i need to show the result where the currency ! = JPY (i.e all results except JPY as below) CNY 100 XYZ INR 100 UUU
... View more