Show Top "X" Scores in a grouped view

[Mark_Hudson]

Apologies, very new to Airtable. I have a view based on a table that has players weekly scores. The view is group by Player Name and Sorted By Score (Desc). In each group I would like to add a rank column so then I add an additional filter to filter by Top x scores per player.
I tried autonumber but would need autonumber to reset for each player grouping.

Any ideas?

Thank you
Mark

[Kamille_Parks]

I explain how to do this on an Episode of BuiltOnAir. See this similar topic for context, instructions, and the script. That thread also links to the episode where I explain how to do this with an Automation

Comparing records in different fields in the same table Formulas

Hi, I have 3 Fields “Name” “Results” “Position” [2] I will like to compare the values in “Results” Field and position it from ‘1st - last row’ (Field “Position”) If “Field Results” Row 1 or Record 1 is > Row 2, then Row 1 = “1st” else If “Results” Record 2 > Record 3, then Row 2 = “2nd” else if “Results” Record 2 = Record 1, then Row 2 = “1st” What I want the “Position” Field to do is, compare if Results Field Row 1 is Greater than Row 2 then Position Field Row 1 is equal to “1st” A…

[Mark_Hudson]

Thank you Kamille. Extremely helpful!