I am Unable to Change Format(Incremental RR is in percentage(%) and rest are in numbers($)) When Using Parameters to Swap Fields. I have created one parameter named -Select metric and written calculation as below:
IF [Select Metric]='Avg HH-Balance' then [Average Balance]
ELSEIF [Select Metric]='CPI-HH (Checking)' then [CPI-HH (Checking)]
ELSEIF [Select Metric]='CPI-A (Any Acct)' then [CPI-A (Any Acct)]
ELSEIF [Select Metric]='Incremental RR' then [Incremental Response Rate] else null
The format it's taking is Automatic but I want the axis to change according to the selection of parameters.Thanks.