Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAUsed multi-row tool to calculate rank. Liked seeing Tile example also posted.
Piece of cake!
First off, sort the data set
then add a RecordID
The trick here is to use a multi-row formula that creates the ranking, grouped by the # of count
Then we filter based on just the Top 5 ranked
And finally, a Select to clean up the data