4 Replies Latest reply on Jul 2, 2014 8:52 AM by Matt Lutton

    Sort Order of Period in Quick filter

    mehak jaggia


      Hi,

       

      I have a PERIOD in my data whose values are as 2012-01, 2012-02, 2012-03.......etc. I have edit alias and changed it to Jan12, Feb12, Mar12..... til date(July14)

      Now when I am using this PERIOD in the quick filter I am getting the values  in the order as APR12, APR13, APR14, Aug12, Aug13.....,....( coming in the alphabatical order).

       

      My requirement is to get this period values in the chronological order as  Jan12, Feb12, Mar12.... Jan13, Feb13......Jan14, Feb14

      I have also attached the .twbx file also.

       

      How can I do the same??

       

       

      Regards,

      Mehak