Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello!
Please, see the attachement. Is this what you want to get?
Thanks. Very helpful . My issue is resolved using this expression.