Rank function problem

[#1]

Hi,

i have this situation, top 10 agencies with decrescent value:

I need to have for every agency the max value Area.

How can i do?

I have two dimension:

Agency as calculated dimension  = "if(aggr(rank(sum(Value)),[AGENCY NAME])<=10,[AGENCY NAME]) "

and Area as normal dimension.

Thanks a lot

[Gysbert_Wassenaar]

Try FirstSortedValue(Area, -aggr(sum(Value), Agency, Area)) as expression to return the Area and max(aggr(sum(Value),Agency,Area)) as expression for the maximum sum of value.