Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I have a requirement in which I have 2 columns CP Country and IM Country and I want if I select 'A' from CP Country , it should select the rows corresponding to 'A' in CP Country and rows corresponding to 'A' in IM Country.
Please find attachment for sample.
Please check the solution in the attachment.
You can do that using trigger action 'Select Possible' as shown in the sample app attached.
thanks for your reply , but the requirement is like when I select 'A' from CP Country the count of ECI should come as 4 , i.e the rows for IM Country also get added when 'A' from IM Country is selected.
It seems that you need to work on Set analysis instead of looking for selection manipulation. I have made a small change in the script to treat the nulls in INLINE load properly. And then use expression like:
=Count(DISTINCT {$+<[CP Country],[IM Country]=p([IM Country])>}ECI)
Thanks , but for B , C also it is calculating A although it should be like that if you select A from CP Country then IM Country A should pop up and when you select B from CP Country the if B is present in IM country then only there count should be consider otherwise it should give the actual count of B in CP Country.
Please check the solution in the attachment.