Variable with field name inside

[danosoft]

I have a variable in my load script that have a field name:

varOne = "fieldName"

i want use the values of that fieldName in my chart dimension, how can i do that?

if  i use in my dimension $(varOne) it write only the fieldName and not all values at that filedName have in my table....

[sunny_talwar]

May be add an equal sign

$(=varOne)

[danosoft]

no, it not work

[sunny_talwar]

Would you be able to share a sample to show your issue?

[asinha1991]

maybe this

[ $(varOne)] 

or " $(varOne)"

[danosoft]

no it show the fieldName not the values

[danosoft]

This is the example, i try to explain it:

- when in the Dimension table i select "AGENTE"

i want in the Chart table see on the rows:

agenteuno

agentedue

agentetre

and NOT the name of the field

[sunny_talwar · Accepted solution]

Try this

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

[danosoft]

thanks it work!! can you explain the solutions? thanks

[sunny_talwar]

Dollar sign expansion converts a text into a field name... $(Variable) gives text, $(='[' & $(Variable) & ']') gives [FieldName]