Max(Aggr(Rank()))

[Kartik11]

Movie Name	Ranking	Score
Aa	A	5
Bahuballi	A	5
Colli	A	5
Dady	B	3
Jani	A	5
Kani	C	2
Munna	B	3

I want to Max Min Value Using Aggr(Rank()) Function

[Kartik11 · Accepted solution]

can please help me any one

[vinieme12 · Accepted solution]

Do you need min/max or rank ?  what is the expected output

[Kartik11 · Accepted solution]

Max =Bahubali-5

Min=Kani=2

[vinieme12]

Lowest

aggr(if(rank(-Score,4,1)=1,MovieName&'-'&Score),MovieName)

Highest

aggr(if(rank(Score,4,1)=1,MovieName&'-'&Score),MovieName)

[Kartik11]

Thanks for Helping