Month sorting

[learner03]

I wanted to have last 6 months in matrix and months as colomn. So, I used an If condition as a column as-

Now all the months before 6 months have "neither" as a text in column

In matrix visual I am getting-

I want to sort this and if I am trying to sort this by Month Id then it says that it cannot sort as multiple Monhts have "neither" status.

How can I sort this?

[Greg_Deckler · Accepted solution]

@learner03  Create the same calculated column but return the month number or 0 for Neither and sort by that?