8 Replies Latest reply: May 11, 2018 10:55 AM by vishal raina RSS

    Rank a Table

    vishal raina

      Hi All,

       

      I have the data in the below format & want to rank as per the sales grouped by year. The rank should come as below in Red.

       

      WeekYearSalesRank
      120172004
      120161005
      220174001
      220163002
      320165001
      320172503
      420173302
      420161504
      520162203
      520171505

      I'm able to rank across the tables irrespective of the year, but i need  the result year wise as above. I thought using the aggr function should have solved this, but somehow unable to get the desired result. Any help on this is much appreciated.