Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
vEndvalue is variable which get 1,2,3,4,5,6 on selection. These are fields to display in chart :
Name,[GState],[GCountry],[Sales Area],[Sales Region],[Seller Name]). I need to write set analysis for the below expression
if ('$(vEndvalue)' = '' ,Name,Pick(Match('$(vEndvalue)',1,2,3,4,5,6),Name,[GState],[GCountry],[Sales Area],[Sales Region],[Seller Name]))
Not sure, but may be this:
Pick(Alt($(vEndvalue), 1), 'Name', 'GState', 'GCountry', 'Sales Area', 'Sales Region', 'Seller Name')