Rank Issue

[Anonymous]

Hi all

My requirement is show student ranks based on their percentages in table when we select the student in table

it should show name and rank in another text boxes

here issue is :

before student selection rank is working fine like below

before selection Satya rank is 3

after student selection its showing as 1

but even after student selection i should see same rank(3) in table and also in text boxes

Attached APP for more details

swuehl‌stevedark‌

thank you

SRP

[adamdavi3s]

Try using =aggr(rank(sum({<Student -=>}Percentage)),Student)

[Anonymous]

Appreciate your quick help

but its not working still showing rank as 1 when i select student

[adamdavi3s · Accepted solution]

Working fine here?

[Anonymous]

yes its working i missed aggr() function

[adamdavi3s]

Brill, sorry I missed it first and had to edit my answer so that was probably the issue!

[Anonymous]

  yeah even i was in confusion whether i tried previous ans properly or not anyway thank you adam!