I have an input variable where a user can select a dimension from a drop down list to be displayed in a table. Variable is vCyclic1Value
The table then has a field defined as ='$(vCyclic1Value)' and this works for all dimensions except for the calculated dimension. For the calculated dimension (BalG) it displays “BalG” in each row of the table instead of the result of the calculated dimension. If I add the calculated dimension "BalG" to the table as a column it displays the result of the calculated dimension correctly.
My calculated dimension (BalG)
=class( if([Balance]<$(VBalanceStart), $(VBalanceStart)-1 ,
if([Balance] > $(VBalanceEnd), $(VBalanceEnd)+1 ,[Balance]))
, $(VBalanceWidth), 'X', $(VBalanceStart)
)