Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Show Top "X" Scores in a grouped view

Topic Labels: Formulas
126 2
Showing results for 
Search instead for 
Did you mean: 

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!