Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.