Month Sorting changes when new data is added.
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?