This content has been marked as final. Show 4 replies
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:
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?