1 Reply Latest reply: Jan 31, 2017 2:55 PM by Vineeth Pujari RSS

    Expression changes

    chandu xyz

      Hi

       

      I am facing an issue in frond end.there is a pivot table with below Dimension and Expressions

       

      Dimension:

      =Pick(Dim, Timeperiod,'Forecast', 'Actual - Planned', 'Forecast - Planned')

       

      Expression:

      =Pick(Dim, Sum(Value),

           top(Sum(Value), RangeMax(ColumnNo()-1,1)),

           Sum({<Timeperiod = {'Actual'}>}Value)-(Sum({<Timeperiod = {'Planned'}>}Value

            (Top(Sum(Value), RangeMax(ColumnNo()-1, 1)))-(Sum({<Timeperiod = {'Planned'}>}Value)

         

        I am getting correct result but problem is representation of Object. There is no fields as dimension like 'Forecast','Actual - Planned', 'Forecast - Planned' using pick function.

       

      But i dont want single expression  there any other option instead of pick function

       

      i need below Individual Expression in chart as per requirement:

       

      Forecast :                top(Sum(Value), RangeMax(ColumnNo()-1,1)),

      Actual-Planned:        Sum({<Timeperiod = {'Actual'}>}Value)-(Sum({<Timeperiod = {'Planned'}>}Value

      Forecast-Planned:     (Top(Sum(Value), RangeMax(ColumnNo()-1, 1)))-(Sum({<Timeperiod = {'Planned'}>}Value)

        • Re: Expression changes
          Vineeth Pujari

          Dimension use valuelist

          Valuelist ('Timeperiod','Forecast', 'Actual - Planned', 'Forecast - Planned')

           

          Expression

          If (Valuelist ('Timeperiod','Forecast', 'Actual - Planned', 'Forecast - Planned') ='Timeperiod'

          ,expressionfortimeperiod,

          If (Valuelist ('Timeperiod','Forecast', 'Actual - Planned', 'Forecast - Planned') ='forecast',

          Expression for forecast,

          ...and so on