I have two columns that I want to apply order by on :
- The first column is Year. I’d like the data table to be ordered by Year in descending order.
- The second column is the department code - example Environment ENV, Humain Resources HR etc.
My data table has severals columns. So the aim to is to order firstly by Year in descending order followed by an order by on the Department Code column in ascending order. So for a given year, example 2019, I should have Department codes listed as ENV, FIN, HR, IT etc.
I was able to order the column Year in descending order but the department was not listed in the correct order as I would like.
Thank you all in advance