Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to select other fields in a list box automatically?
I would like to have Budget New Retail and Volume automatically selected if I select B/W Budget New Retail.
My metrics are set up like this:
I have tried using Document Properties>Triggers>Field Event Triggers with no success, here is what I tried:
Using _metrics_SR:
=If(_metrics_SR='B/W Budget New Retail', '(B/W Budget New Retail| Volume Retail | Budget New Retail)', '('&Concat(DISTINCT _metrics_SR, '|')&')')
Using _metricsNo_SR:
=If(_metricsNo_SR = 113, '(113|109|80)', '('&Concat(DISTINCT _metricsNo_SR, '|')&')' )