Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Ok I see, then here it is:
Only( {< DATE={'$(vDATE)'} >} AGGR(RANK(SUM(MValue_KS)),DATE))
Something like:
Only( {< DATE = {"=Rank(SUM(MValue_KS))=$(=MAX(AGGR(RANK(SUM(MValue_KS)),DATE)))"} >} DATE)
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.
Ok I see, then here it is:
Only( {< DATE={'$(vDATE)'} >} AGGR(RANK(SUM(MValue_KS)),DATE))