Find the maximum value, corresponding dimension

[qingkong]

I want to find the maximum qty value of the Country, and the maximum value should return the details of the Country

Let's say the maximum value of Country is 20000, and the corresponding Country is US

[joostvanegmond7 · Accepted solution]

Although this might be not a GeoAnalytics question, you should use the following formulas: 

For getting the maximum qty value:

=max(aggr(Sum(qty),Country))

For getting the corresponding country: 

=FIRSTSORTEDVALUE(Country,-aggr(sum(qty),Country))