Set anlaysis

[aaronnayan]

Hi Guys

How would i show which City as a Value has the highest sales ?

Not the sales number

[shraddha_g]

FirstSortedValue(City , Sum(Sales))

[aaronnayan]

I need it to show the city that has the highest sales

[agigliotti]

what object type are you using?

[aaronnayan]

KPI

[agigliotti]

maybe this:

=Only( Aggr( if( Sum(Sales) =  Max( total Aggr( Sum(Sales), City) ), City, Null() ), City) )

[sunny_talwar · Accepted solution]

May be this

FirstSortedValue(City, -Aggr(Sum(Sales), City))

or

Concat(Aggr(If(Sum(Sales) = Max(TOTAL Aggr(Sum(Sales), City), City), City), ', ')

[Mark_Little]

Hi Aaron,

Try something like

IF(RANK(AGGR(SUM(SALES),CITY) = 1,ONLY(CITY))

Mark