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
Icon for Super User rankSuper 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...