Sort after max year to date

[cosminc]

Hi

i need to buid a graph with top Salsmen for last 3 years (2019 inclusive)

what expression do i need to sort after main year, 2019 in this case

i use a calendar (1 jan 2017 till 31 dec 2019) connected with the data base

let's take a simple example

salesman    sales  year  month

thanks!

Cosmin

[v-chuncz-msft]

@cosminc ,

The requirement is not very clear. You may check RANKX and TOTALYTD.

[cosminc]

hi,

see above for what i need

now the sortation is on a sum for all 3 years

more than that i want 2019 to be first not last on this graph

thanks,

Cosmin

Cosmin