Evaluating Variable within another Variable

[#1]

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?

[swuehl · Accepted solution]

Try

='[' & pivotDim1 & ']'

edit:

or

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

[Anonymous]

Hi Andy,

try this instead for your calculated dimension:

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

Let me know how it goes and if you need me to explain how it works

Boris

[#4]

The expression without the dollar sign worked!

[#5]

It didn't work, but I was able to fix it by removing the dollar sign.