Nov 11, 2022 08:44 AM
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?
Solved! Go to Solution.
Nov 11, 2022 09:30 AM
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)
Nov 11, 2022 09:30 AM
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)
Nov 11, 2022 09:58 AM
OMG, thank you. DOH! Appreciate the insight.