4 Replies Latest reply: Jun 20, 2014 1:20 PM by Andy Levine RSS

    Evaluating Variable within another Variable

      I have a chart where the user selects the dimension from an input box. For dimensions that are more than one word, the dynamic chart doesn't work because I need brackets around the name:

       

      Example:

      If the user selects Target Line, I need to pass [Target Line].

       

      I created a new variable using the code:

      ='[' & $(pivotDim1) & ']'

       

      But this only returns [] without the selected dimension between brackets. My pivotDim1 variable works fine for reading the selected name, so this variable is not the problem. Any suggestions?