Months Without Alphabetical Order

[rwicker]

My reports keep putting the "Month" in alphabetical order. How do I get it to know that I need them in calendar order? Thanks!

[CharlieS · Accepted solution]

@rwicker

I recommend creating a new field that converts the current date labels to a numeric format by using the following formula DateTimeParse([Name],"%b_%Y"). This new field can be sorted and this will correct your chart.

An example solution is attached.

[rwicker]

Thank you Charlie!! This worked perfectly and has solved so many issues with other reports. ! Thanks again!