Peek rank for variable value

[MT4T]

Hello,

I have this table as a sample.

My question is how to peek value of rank for specific DATE defined by variable? 

I want to build text and image object which will say "last report rank is xx out of yy".

I know how to define yy - MAX(AGGR(RANK(SUM(MValue_KS)),DATE))

But with xx i have a problem.

Thank you in advance.

[vincent_ardiet_]

Something like:

Only( {< DATE = {"=Rank(SUM(MValue_KS))=$(=MAX(AGGR(RANK(SUM(MValue_KS)),DATE)))"} >} DATE)

[MT4T]

Thank you, your function could be especially useful. 

But i need to do it in another way. 

My variable vDATE = '10.10.2023' i need to get rank for this day which is "112" according to sample pivot.

[vincent_ardiet_ · Accepted solution]

Ok I see, then here it is:

Only( {< DATE={'$(vDATE)'} >} AGGR(RANK(SUM(MValue_KS)),DATE))