Sort by more columns

I want to sort Data by two cretaria I mean two columns :
[_Rownumber] ascending
[2column] descending
but in fact the app sort only by the first column selected ,while the second one it doesn’t take it in consideration

I think when sorting by RowNumber, any secondary sorting would be ignored because technically speaking there should only be one row number of each. Secondary column sorting has at least some dependency on that the primary column sorting will come across some duplicates.