Inverted rank function

[Anonymous]

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

[jonathandienst]

>> but it's not working the way I want...

I think you need to describe what it is you want.

[Anonymous]

I would like to have the minimum date in the rank 1 instead of the maximum rank

[OmarBenSalem]

aggr(rank(-sum(Date),ID),ID)

[Anonymous]

I tried the following expression : =Count(TOTAL MSN)-rank([New Total Date début])+1

It seems to work.

Thank you for answering !

[agigliotti]

let's try using the below expression for Rank column:

Rank( Total -Date, 4 )

[Anonymous]

= Count(Total ID) - rank(date) +1