Dynamic string to Field (evaluate at each record)

[#1]

Is this even possible?  I am trying to turn a string into a field; however, depending on the dimension, the string is different.  currently I am just getting nulls returned.  the 4th column in the below is what I am trying to do; however it always returns null. 

dim1      | Val_A | Val_B | $(='Val_' & dim1)

A           | 4.5     | 3.1     | 4.5

B           | 2.1     | 1.7     | 1.7

[swuehl · Accepted solution]

No, the dollar sign expansion is not evaluated per dimension, only once per chart.

[#3]

booo, well that's a shame