3 Replies Latest reply: Aug 3, 2018 3:42 AM by Aruna dabba RSS

    how to arrange the dates in order?

    chaitanya krishna

      Hi

       

      I have moth field data like

       

      Month:

      Jun-2016

      Jan2016

      Feb-2008

      Dec2008

      Mar-2017

      Apr-2018

      Nov-2017

      Jan-2007

      Feb-2007

      Dec-2016

      Aug-2018

      Nov-2008

       

      I am creating chart and calculate the rolling 12 months and I am using above month field in a dimension.

      problem is my dimension not showing order. I want display the month field in proper order.first2018 and 2017 ...

       

      like  Aug-2018 Apr-2018  Nov-2017  Mar-2017  Dec-2016 Jun-2016  Jan2016  Dec2008  Nov-2008  Feb-2008  Feb-2007 Jan-2007

       

      How to do this. Please help on this.

       

      thanks.