Variable is showing same value for dimension cells

[prasadreddy]

Hi All,

I had an issue in expression,

I have created one variable, called vPrice, below is the expression

= (Sum(Value_S) / Sum(Value_VK)) * 1000

Expression in pivot table chart is:

= IF([P&L Item] = 'Price $/MT', $(vPrice), Sum(Value))

Please see the attched image for values showing in pivot table chart.

If I remove '=' sign before variable expression the perticular line is not showing in pivot table

[P&L Item] and Month are dimensions in chart.

I want display variable values with respect to the Month dimension.

Thanks,

Sampath

[tresB]

Removing '=' should have worked. Could you post your sample qvw to check?