Rank as an expression within dimensions

[#1]

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

[ceciliafujita]

Hi Nicole,

I'm have the same problem. Did you solve yours?

[ceciliafujita]

Hi Nicole, i solved: AGGR(NODISTINCT(RANK( $(yourMetric)_or_Formula())), DIM1, DIM2)