6 Replies Latest reply: Mar 13, 2018 6:14 AM by Caroline Huet RSS

    Inverted rank function

    Caroline Huet

      Hello,

       

      I have the following table :

       

      IDDate
      110/11/208
      209/11/2018
      312/11/2018
      407/11/2018

       

      I would like to add a rank function in order to know the order of each product. I would like to have the the first date as number 1 like following

       

      IDDateRank
      110/11/2083
      209/11/20182
      312/11/20184
      407/11/20181

       

      Could you please help me ? I tried the rank function but it's not working the way I want. And I would like the function to adapt to others filters that I can have...

       

      Best regards,

       

      Caroline