5 Replies Latest reply: May 5, 2015 5:12 AM by Hasvine Dhurmea RSS

    Sorting of month.year

    Hasvine Dhurmea

      Hello Everyone,

       

      Can someone urgently help me in resolving this issue:

       

      I have created my 'month.year' field in my script using the below line:

       

      Load:

      month(subfield([date], ' ' ,1)) &' '& Year(subfield([date], ' ' ,1)) as monthyear,

       

      and it works perfectly.

       

      However, when i create a bar chart with it, I do not manage to sort the date correctly.sort fail.PNG

       

      I tried to sort it in all possible ways in the ''Chart Properties tab Sort'' but nothing works.

       

      Thanks,

       

      Hasvine