Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can please help me any one
Do you need min/max or rank ? what is the expected output
can please help me any one
Do you need min/max or rank ? what is the expected output
Max =Bahubali-5
Min=Kani=2
Lowest
aggr(if(rank(-Score,4,1)=1,MovieName&'-'&Score),MovieName)
Highest
aggr(if(rank(Score,4,1)=1,MovieName&'-'&Score),MovieName)
Thanks for Helping