sort by year then month

[icarecenter]

I want to sort by year first then by month.  I also want to group by month year.  I can't seem to figure out why it doesn't sort by the month value.

[TeeSee1 · Accepted solution]

The sort order is first by the grouped columns and then by the sort columns on the final rows expanded.

So your MonthYear is used first to "alphabetically" sort in an ascending order.

I guess the best you can do is to group by Year, Month Number, Booking Platform and order by Guests.