Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have been search the forum for a few days on the Rank function and have not come across anything similar to my scenario.
I need to rank a dimension (Item #) within a second dimension (Store #) by an expression (sum(Qty)). I know I will need to use an aggr to group within the Store # dimension, but have not been able to come up with the right syntax to get to my result.
Here is where I started: aggr(rank(sum({$<Year={$(=max(Year))}>}QTY), 0, 1), ITEM#, STORE#) (not working)
Here is my desired result:
Please help if you can!
Thank you,
Nicole
Hi Nicole,
I'm have the same problem. Did you solve yours?
Hi Nicole, i solved: AGGR(NODISTINCT(RANK( $(yourMetric)_or_Formula())), DIM1, DIM2)