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?
Page 1 / 1
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.