Sorting MonthYear in ascending order

[mhapanka]

Hi team, I urgently require help on my dashboard. 

I am creating a dashboard from an attached csv file. I have a field called YearMonth that contains values like Jan-06,..,Mar-06, Apr-06,May-06 etc and so on till Dec-07.

I need to sort these in ascending order  so that they are in the order mentioned above rather than what can be seen in the picture. Could someone please help me out with the code for this?

Greatly appreciate your time on this,

Thanks

[christophebrault]

Hi,

You can try to edit the load script and use

Monthname(date#(YearMonth ,'MMM-YY')) as YearMonth

This should convert your field to a dual with the date#() function and allow to to sort properly