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.

       

       

       

      Thanks,

      Sampath