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...

...any insight on what may be going wrong would be appreciated.

 

Need Help

4 Replies

  • 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