jamzl opened a new issue, #28148: URL: https://github.com/apache/superset/issues/28148
### Bug description When using metrics as rows in pivot table, sorting is done by row at the most granular level, not by series. E.g. when sorting by Key A-Z, metrics are displayed correctly under their parent in the series. ![image](https://github.com/apache/superset/assets/143793833/966fc2da-362c-41e0-9952-a8e4cd976da9) However, when sorting by Value, sorting is done by row, not by series (e.g. "Puzzle" genre is now split into 3 separated rows) ![image](https://github.com/apache/superset/assets/143793833/cb0836b6-1f8c-466b-8766-a95f8e87970c) I've spent a lot of time searching for solutions for this, nothing came up. ### How to reproduce the bug 1. Create Pivot Table 2. Select >1 metric 3. Select metrics as rows 4. Go to "Customize" and choose sort by values ### Screenshots/recordings _No response_ ### Superset version master / latest-dev ### Python version 3.9 ### Node version 16 ### Browser Chrome ### Additional context _No response_ ### Checklist - [X] I have searched Superset docs and Slack and didn't find a solution to my problem. - [X] I have searched the GitHub issue tracker and didn't find a similar bug report. - [X] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org