Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Removing '=' should have worked. Could you post your sample qvw to check?