Month Sorting changes when new data is added.

Hi All,

I have a column "Month" which refers month and week (2018-18). I derived this column from a date column with the format mm/dd/yyyy.

I did a reverse sort for the month column so it shows the latest Year and week in the top for filter.

But whenever a new data is added, like new weeks data, the latest week comes in the buttom. How can I fix this?


(2) Answers