Variable is showing same value for dimension cells

prasadreddy — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Variable is showing same value for dimension cells

tresB — Tue, 21 Nov 2017 09:38:43 GMT

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