Forum Discussion
Helper IRANKX showing duplicated values
tex628 Thanks for all the help i already found a way to show the information i wanted so instead of using my SchoolName i used the ClassID and now its showing the results i wanted .
As my ClassID they have schools names abbreviated as for examples PORGpsi1619 , i made table with the abreviattions and the school names so in the meetups people can understand what the 3 first letters means
Community ChampionMay I ask what is the purpose of creating this ranking, is it to filter on rank or simply to display the rank?
/ J
Helper Itex628 the purpose of this rank is to show in meeting to show the top 5 class with more "MódulosAtraso" in our group of Schools , the ranks its already filter to show only top 5
- tex628
Try this:
Go into filtersChosoe Top N instead of basicWrite 5 in top and then by value "ModuloAtraso"
- rui_silva
tex628 Hey i tried your method but it doens't filter top 5 neither gives me only top 5 as i would like as this :
School ClassName MódulosAtraso Rank
Porto Class1 900 1
Viseu Class1 760 2
Viseu Class90 750 3
Porto Class20 600 4
Porto Class19 550 5
- tex628
Sorry i was away at lunch.
I think theres something im missing or missunderstanding, do you think you could provide a picture of your visuals?
/ J