Skip to main content
rachelhibbardtmo
Contributor ⭐️⭐️⭐️⭐️
April 27, 2022
New Idea

Ability to sort months chronologically

Related products:CS Reports
  • April 27, 2022
  • 2 replies
  • 146 views

In Report Builder, you have the ability to create a formula field to return Month name. However, you are unable to sort that field chronologically now and are stuck with months in alphabetical order which is undesirable.

Months sorted alphabetically

 

Desired order for months listed above would be:

  1. January
  2. March
  3. April
  4. June

 

A proposed workaround is to have an additional column with the date field to sort on. However, this does not work if you have row grouping enabled for your Month name field, as sorting function sorts count of dates and does not sort the underlying dates.

 

2 replies

kstim
Helper ⭐️⭐️
August 22, 2022

+1 Yes please!!! This would greatly simplify reporting on dates in the report builder.

brlayman2583
Helper ⭐️
November 18, 2025

Bringing this one back up to the surface. We’re encountering an issue with needing a formula showing month name with annual result in a ling graph...except that it’s sorted alphabetically which is unhelpful. it would be great if at the very least we could add advanced formulas to give number values so we could sort