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

Reply


Terms & Conditions