Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following table :
ID | Date |
---|---|
1 | 10/11/208 |
2 | 09/11/2018 |
3 | 12/11/2018 |
4 | 07/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
ID | Date | Rank |
---|---|---|
1 | 10/11/208 | 3 |
2 | 09/11/2018 | 2 |
3 | 12/11/2018 | 4 |
4 | 07/11/2018 | 1 |
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
>> but it's not working the way I want...
I think you need to describe what it is you want.
I would like to have the minimum date in the rank 1 instead of the maximum rank
aggr(rank(-sum(Date),ID),ID)
I tried the following expression : =Count(TOTAL MSN)-rank([New Total Date début])+1
It seems to work.
Thank you for answering !
let's try using the below expression for Rank column:
Rank( Total -Date, 4 )
= Count(Total ID) - rank(date) +1