What you describe is already possible, but only if the score question is numeric:
If you can, please create a sample project with some dummy data and share the project link here publicly.
It seems like you already calculate the score within the form with a calculate question, so that each row is for one participant and already contains the score to be displayed in the screenshot.
There are two steps needed here:
- Reports need to be expanded to handle calculate questions
- The results table should be made sortable
The first item needs to accommodate all kinds of scenarios since calculate questions can be text or numbers. So I imagine the need for a user to define how the calculate question needs to be handled: 1) display all values submitted (as in current text questions) or 2) display the average (or 3) display the sum). In your example, any of these options would work if there is exactly one submission per participant, but for most forms that wouldn’t be the case.
The second item would be an extension for all tables displayed when the ‘group by another question’ feature is used. Users could then sort by either the grouping question or the results question. I think a global setting for the whole report would be easier.