Forum Discussion

cosminc's avatar
cosminc
Post Partisan
7 years ago

Sort after max year to date

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
Need Help

2 Replies

    • cosminc's avatar
      cosminc
      Post Partisan
      7 years ago

       

       

      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