2 Replies Latest reply: Aug 28, 2018 11:00 PM by haifeng zhao RSS

    Custom sorting issue

    haifeng zhao

      Hi All,

       

      Now we faced the challenga as below regarding custom sorting, sometimes sorting not works.

       

      For dimension,

      if(GetFieldSelections(Periods)='Qtr',Qtr,[M o n t h])

       

      Sorting:

      We try both of below two ways, all of them sometimes not works,

       

      if(GetFieldSelections(Periods)='Qtr',QUARTER_SK,

      MONTH_NUMBER))

      QUARTER_SK----- for example 201501, valus was 01, 201502 value was 01, 201504 value was 02, 201601 value was 05....

      MONTH_NUMBER--For example 201501 value was 01, 201502 value was 02, 201601 value was 01,201602 value was 02.....

       

      if(GetFieldSelections(Periods)='Qtr',

      Match(Qtr,'Q1','Q2','Q3','Q4'),

      Match([M o n t h],'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'))

       

      Both of them sometime not works, i dont know which part ran wrong ,

      Is there any way I can do this custom sorting? Thanks.


      Best Regards,

      Haifeng

        • Re: Custom sorting issue
          Jonathan Dienst

          Test the two parts of the sort expression in text boxes -

          Does Match(Qtr,'Q1','Q2','Q3','Q4') work as expected when you select a single possible value for Qtr", and

          does Match([M o n t h],'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')) work correctly when you select a single value of [M o n t h]? This may help pin down the problem.

           

          Also be aware that if nothing is selected, then f(GetFieldSelections(Periods)='Qtr', will always return false.