
Hi i have a sharepoint list with this format
| Title | User | Score |
| Match | spiderman | 10 |
| Match | batman | 15 |
| Match | batman | 8 |
| Match | spiderman | 7 |
| Match | thor | 1 |
| Match | batman | 8 |
| Match | thor | 7 |
| Match | thor | 2 |
| Match | thor | 2 |
i want to create a leaderboard showing something like
1) batman - 31 with 3 entries
2) spiderman - 17 with 2 entries
3) thor - 12 with 4 entries
how can i put that in a table? what's the code to get the number of entries and the total score for each user?
thanks
HI @Antonioclk ,
Try
AddColumns(
GroupBy(
SPList,
"User",
"Data"
),
"TotalScore",
Sum(
Data,
Score
),
"Entries",
CountRows(Data)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps