Understanding Group + Sort by

[Jac_Evans]

I have a table full of sales figures. Each row has a sale month column which is Apr-19 for example.

In a view I want to show all the sales grouped by month but the groups be in order, like:

Nov - 18
Dec - 18
Jan - 19
Feb - 19

etc.

How do I do that? A-Z doesnt work and neither does 1-9 etc.

Thanks!

[Elias_Gomez_Sai]

What type of field is that? You have 2 options:

• Write a number for the month at the beginning
• Use a Date field and then create a Formula field to the the month number with MONTH()

[Jac_Evans]

Hi - thanks for the reply.

Its a formula feild taking MMM-YY from a date

[Jac_Evans]

I just tried MMYY but it will only let me sort A-Z despite the output being numbers?

[Jac_Evans]

Got it - had to group by year num + then by month num