0 Replies Latest reply: Apr 23, 2018 4:11 AM by haifeng zhao RSS

    Sort for GetFieldSelections() dimension

    haifeng zhao

      Dear all,

       

      As we want to used GetFieldSelections() fuction to judge the dimension, but if we used GetFieldSelections(), for sort we used the specific field, it's not useful.

       

      As per test, if we used the specific field in the dimension the sort works. So all, who can help me how to set sort for GetFieldSelections() fuction.

       

      Sort not works :

      Dimension:

      =Pick(Match(GetFieldSelections(Periods),'Quarter','MAT','Monthly','YTD'),

      YearQtr,

      [Y e a r],

      YearMonth,

      null()

      )

      Sort:

      if(GetFieldSelections(Periods)='Qtr',YearQtr,if(GetFieldSelections(Periods)='MAT',[Y e a r],

      IF(GetFieldSelections(Periods)='Monthly',YearMonth)))

      Sort work:

      Dimension:

      YearMonth

      Sort:

      Sort:

      if(GetFieldSelections(Periods)='Qtr',YearQtr,if(GetFieldSelections(Periods)='MAT',[Y e a r],

      IF(GetFieldSelections(Periods)='Monthly',YearMonth)))