Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 max average from every country for this category=1, despite the country changes in the multibox. In other words, i want to return a static number that is the value of the max average for the country that ranks first of all averages. Can anyone help me on this please ??
Thank you!
TH
Max({<Country = >}TOTAL Aggr(Avg({<Category = {1}, Country = >}Amount),Country))
=Aggr(Rank(Avg({<Category={1}, Country= >}Amount)),Country)
Mr Manish I need the value of the maximum average that ranks first of all countries for this category=1, not the rank of the selected country as you had correctly answered me on another post @Simple Rank expression.
Thank you very much for your valuable time
Max({<Country = >}TOTAL Aggr(Avg({<Category = {1}, Country = >}Amount),Country))
That was exaclty I needed. Thank you again.
Your sincerely,
TH