Forum Discussion

samioberoi's avatar
samioberoi
Icon for Helper III rankHelper III
3 years ago
Solved

Sort quarters as per academic year

Hi    I want to sort Sep-Nov as Q1, Dec-Feb as Q2 so on and so forth. I managed to add a calculated column changing September to Month number 1, Oct to Month number 2 etc. & then used the switch st...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi samioberoi ,

     

    You should sort your text range column by a numeric column.

    You can create a numeric column like this.

    QuarterNumber = SWITCH(MONTH([Date]),9,1,10,1,11,1,12,2,1,2,2,2,3,3,4,3,5,3,6,4,7,4,8,4)

    Sort by [QuarterNumber].

    You can download my attchment for more details.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Have you sorted the final column by the one you previous created (the one that as the quarters as numbers)?

  • samioberoi's avatar
    samioberoi
    Icon for Helper III rankHelper III
    3 years ago

    Hi

    Yes, i did sort the final column by the previoulsy created column giving the column number. It still shows the columns in the wrong order.

     

    Thanks