Say I have data for 3 countries, USA, UK, and Canada and I set three variables.
vUSAScaling = .1
vUKScaling = .2
vCanadaScaling = .3
I'd like to have a measure that is
sum(Sales) * $(vCountryScaling) and have the value of vCountryScaling reflect my selection for country. I have tried doing something like $('v$(=GetFieldSelections(Fund))Scaling') but have not had any luck. Does anyone have any ideas?
will work but now I am running into a different issue. I want to have a table like below with my measure using the dynamic variable but since I am not making selections it will not work. I have tried using $(=concat('v' & concat(distint Country) & 'Scaling')) but it is not working.
USA sum(Sales) * $(=Concat('v' & getfieldselections(country) & 'Scaling'))