1 Reply Latest reply: Nov 21, 2017 4:38 AM by Tresesco B RSS

    Variable is showing same value for dimension cells

    Sampath k

      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.