Show Top "X" Scores in a grouped view

Topic Labels: Formulas
1016 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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

2 Replies 2

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

Thank you Kamille. Extremely helpful!