bigger size wins ---aggr rank ?

[alexpanjhc]

i have a table 

Load * Inline [

Team, Name, Win, Rank

A, Wladimir, 31, Team Lead

A, Paul, 22, Technical Support Engineer

B, Mark, 40, Customer Support Engineer

B, Janne, 27, IT Specialist

];

for each team  i need to find the the name of most numbers of Win of the team and use the rank of that name to get a new table as below

Team ,Rank

A,Team Lead

B ,Customer Support Engineer

was thinking to do 

rank :    only({<Name={"rank(sum(win),1)=1"}>} rank) but not wworking

i tried a lot of things now my brain stopped working, maybe someone can help me with a solution?

thanks!

[tresesco]

Dim : Team
Rank (Exp) : FirstSortedValue( Rank, -Win)

[alexpanjhc]

Hi @tresesco 

thank you for your prompt response, i tired it, my win was a sum of something, and firstsortedvalue does not allow nested aggregation.

any other suggestions please?

.

.

[tresesco · Accepted solution]

To avoid nested aggregation issue, use aggr(), like:

FirstSortedValue( Rank, -Aggr(Sum(.....), Team))