Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
May be add an equal sign
$(=varOne)
no, it not work
Would you be able to share a sample to show your issue?
maybe this
[ $(varOne)]
or " $(varOne)"
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
Try this
=$(='[' & $(varFirDimension) & ']')
Dollar sign expansion converts a text into a field name... $(Variable) gives text, $(='[' & $(Variable) & ']') gives [FieldName]