Skip to main content




Greetings!


I’d created a formula:


CONCATENATE({Month #},“-”,Month)


so that grouping in my table(s) would do so since obviously April would be first in the order, etc. However, when I have it sorted in the chart, as you see, the order is, well, not what I’d expect.


Any suggestions?

It’s alphabetizing those segments, so you would need to put a leading zero before the Month #.



So, for the Month portion of your formula, change it to this:



RIGHT("0" & {Month #},2)


OMG, thank you. DOH! Appreciate the insight.


Reply