use ranked date in expression

[curiousfellow]

I have a table with several calenderdates and results.

Now I want to display the results of the second highest calenderdate.

My expression : Sum({$<rank(calenderdate)={$(=2)}>}results ) does not give any results.

And again i do not understand why

[sunny_talwar]

May be this:

=Sum({<calenderdate = {"$(=Date(Max(calendardate, 2),'YourcalendardateFieldFormatHere'))"}>}results)

[Kushal_Chawda]

=Firstsortedvalue (results , - calenderDate, 2)

[Marcos112]

Hi Sunny

I'm using the rank function that gives me the expected result, the problem is when I filter by a date, the rank returns to 1, so I need it to ignore the selection of that field(Fecha)

Can you help me? Thanks in advance