How to de select Value using Trigger

[mhmmd_srf]

Hi All,

Hope you are doing good.

I have a requirement, Have 2 fields from 2 Table.

Category1 from Table1.

Category2 from Table2.

The requirement is when user selects any value from Category1, same values from Category2 also be selected and vice versa. I am able to implement this using Trigger function.

But User also want if he deselect any value from Category1, same value will be de selected from Category2. I am not able to do this.

Can anyone plz help me on this.

I am attaching the test file.

Thanks,

Sarif

[zhadrakas]

This should work:
=if(GetSelectedCount(Category1)>0, '("' & Concat(DISTINCT Category1, '"|"') & '")')

[kushalthakral]

Hi 

You can write below expression in your triggers for both dimensions

in case of Category 1

=If(GetSelectedCount(Category1)>0,'("' & Concat(DISTINCT Category1, '"|"') & '")','')

In case of Category 2

=If(GetSelectedCount(Category2)>0,'("' & Concat(DISTINCT Category2, '"|"') & '")','')

i have checked this and it is working fine

Thanks

Kushal