Skip to main content

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!

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()

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()

Hi - thanks for the reply.

Its a formula feild taking MMM-YY from a date

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()

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

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


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

Terms & ConditionsAccessibility statement