Can "Rank" function achieve this?

[NZFei]

Please see attached sample application.

Thanks.

[NZFei]

Fantastic. It is working!

Thank you so much for your help!

Cheers.

Fei

[NZFei]

By the way I found the expression
Aggr(rank(Sum({<Store=>} Sales)),Group,Department, Store) has the same result. So the key thing is to use aggr on top of rank.

Thanks again.

Cheers.

Fei