Expression in Variable, summing up when used in Chart

[dmohanty]

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.

[rubenmarin]

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.