Sort data in ascending order according to day
I am bringing day from LIVE model which will act as a dimension in the table. The day values are 1,2,3,4...31. When I select date dimension in rows and sort it to ascending order the values are shown as 1,10,11,12...19,2,20,21,22.....3,30,31,4,5,6,7,8,9.
How to sort the day in ascending order 1,2,3,4...31 ?