Forum Discussion

learner03's avatar
learner03
Post Partisan
4 years ago
Solved

Month sorting

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?

 

 

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

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