Need help with Ranking System

[pdominik148]

We want to build a ranking system for users in our database, we have like Name-Mood-Knowledge-Smartness-Sum, in the “SUM” column we sum the points from the Mood, Knowledge, Smartness and we want the ranking system to list the 1st, the 2nd and the 3rd user’s name with the most points from the ‘Sum’ column.
We have the solution for getting the max points, but we don’t know how to display the Name with most points.
We want it to be like a podium.

[tylerboodman]

Assuming you have their total points as a field under the User
For your text in 3rd place Do a search for Users, sort by score (descending yes):item #3’s Name

The repeat for 2nd and 1st but do item #2 and item #1

[pdominik148]

Thank you mm