Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have a field with values suppose as following:
Field
x
y
z
I have used this values to create an expression where these field values are used for adding the condition like:
=sum({<Field ={'x'}>}Sales)
and the expression label is 'x' in this case and so on for other field values used in separate equation in the chart.
Now the client is stating that the field values will change monthly. So I have to find a solution to dynamically replace the old field values with the new field values in the set analysis and in the expression label dynamically as the field values change.
For example:
Suppose there are now new field values
Field
A
B
C
so now the set analysis should be =sum({<Field ={'A'}>}Sales) and expression label Should be A.
Can anyone please help me with this?
Try using a variable in the set analysis e.g.
Sum( {<$(vSetVariable)>}Sales)
and the variable you dynamically define
Field ={'x'}
Hi Dilip,
There are 5 values in the field and each is used in a different expression and label. How do I use a variable here?