Hi all,
I'm working on a basketball spreadsheet in which I give players a score for their performance in a game. I want my pivot table to rank these scores from highest to lowest, but not compile all the scores of one player in the rankings.
Screen Shot 2023-06-26 at 4.33.01 PM.png
For example, I would want it to be able to display
Kevin Durant 4/27/23 9.4
Lebron James 4/12/23 9
Nikola Jokic 4/12/23 8.7
Nikola Jokic 4/10/12 8.4
And so on, with each score ranked from top to bottom. Right now, I am struggling to separate the combined scores from one player. Attached is what my current output is. (Player and Date Rows, Sum of score as values)
Any help would be greatly appreciated!
Bookmarks