Rank Function with variable

[milindnikumbh]

Dear Experts ,

I am not able to use the variable in rank expression .

I want to search the top 5 ranks in date which is less than or equal to  vdt ( date passed ).

=aggr(if(Rank(Sum(qty))<=5,qty ),  (pdate<=vdt)  )  

=aggr(if(Rank(Sum(qty))<=5,qty ),  pdate  ) is working fine but I am not able to restrict the pdate .

Pleas suggest.

Thanks.

Best Regards,

Milind. 

[Sergey_Shuklin]

Hello!

Please, see the attachement. Is this what you want to get?

[milindnikumbh]

Thanks. Very helpful . My issue is resolved using this expression.