Simple Rank expression

[#1]

Dear all,

I need an expression that returns the following ranking :

I have successfully calculated the following simple average:

Avg( {$<Category={1}>} Amount )

and I have another dimension "Country" in a Multi box and whenever I make a choise, the above average is obviously calculated for the selected country.

What I need is an expression that calculates the ranking of the selected country of this average for this category=1 . Can anyone help me on this please ??

[MK_QSL · Accepted solution]

=Aggr(Rank(Avg({<Category={1}, Country= >}Amount)),Country)

[#3]

That's correct. Thank you very much for your valuable time.