Forum Discussion

lab's avatar
lab
Frequent Visitor
4 years ago

sort by

Hi, I am trying to sort by month number... I have month number in my date table.  I am selecting the Sort BY column under Column tools, but my chart still does not show it as an option to sort by....
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

lab , Make sure your mark month year sort as sort column of month year

 

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

 

 

or for month

Month Year = FORMAT([Date],"mmm")
Month Year sort = month([DAte])

 

 

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

lab's avatar
lab
Frequent Visitor
4 years ago

Thank you.

 In my date table...Month# is a whole number.  

JAn=1

Feb=2

MAr =3 

 

When I select that column to sort by, shouldn't that have changed my table on the report?

That's not working...

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    lab , Sort Asc/desc in three dots. I think that will not come with whole number have one text and another whole number as sort column

    • lab's avatar
      lab
      Frequent Visitor
      4 years ago

      amitchandak 

      Yes, that is what I have, still not working.  Could it have anything to do with my date table being built from a script?