How to sort Month-Year by ascending order?

[posywang]

Hi,

Please see attached QVW for an example. I'd like to sort Month-Year by ascending order which should be from Jan-2016 to Dec-2017. Can anyone help? Your help is greatly appreciated! Thanks.

[sunny_talwar · Accepted solution]

Try this

Rating:

Load Month,Year,

     Date#(Month&'-'&Year, 'MMMM-YYYY') as MonthYear;

LOAD * INLINE [

    Month, Year

    January, 2016

    February, 2016

    March, 2016

    April, 2016

    May, 2016

    June, 2016

    July, 2016

    August, 2016

    September, 2016

    October, 2016

    November, 2016

    December, 2016

    January, 2017

    February, 2017

    March, 2017

    April, 2017

    May, 2017

    June, 2017

    July, 2017

    August, 2017

    September, 2017

    October, 2017

    November, 2017

    December, 2017

];

[posywang]

This is GREAT! I should've looked for help sooner so I can get my 3 hour research time back. Thank you so much for your quick response!