Forum Discussion

Regular Visitor

8 years ago

Solved

Sorting by Month Number

Hello, I have a month and year column. I have created a conditional column which gives me the month number based on the month name. When I try to sort the data by the conditional column(Number), ...

parry2k
8 years ago
rarora20 make sure to change date type for your new column M# to whole number, it is string , you will not get correct sort because with string sort will go like this
1
10
11
12
2
3
4
5
6
7
8
9

and that is the reason you see Jan, Oct, Nov, Dec and so on..

Resolver I

8 years ago

select the data tab
select the column: Month - makse sure that month is your defult
"Sort By Column": Number"

Regular Visitor

8 years ago

Tried it. Still giving me the same result.