Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Its a pretty simple thing, but am stuck somehow.
Created a variable called, V_Expression = Sum {<Set Analysis>} (Sales)
Using the variable in a Straight Table, with a Single Dimension, let's say Product. I would expect it show as like this -
Product | Sales |
P1 | $200 |
P2 | $500 |
P3 | $300 |
Where as its showing as -
Product | Sales |
P1 | $1,000 |
P2 | $1,000 |
P3 | $1,000 |
Please help on how to still use the expression in Variable and use the variable in Chart.
Hi, I think the variable content starts with an equal sign, so it is evaluated globally, and the result is shown in the chart.
To filter by dimensions remove the starting equal sign, this way only the expression goes to the chart, not the result, and dimension values are applied.