It would be helpful to be able to sort by columns that are not necessarily included as a column in the list report. This functionality is available in other report types as noted in https://blog.aha.io/better-product-management-analytics/
Thank you for your idea. As noted in the idea, it is possible to sort pivot tables by fields not included in the report. One approach would be to structure your pivot table so that it is formatted similarly to the list. For example:
Add the name field of the primary record type as rows
Add all other fields as cells
On the report, click Customize styles and choose to show cell headers
Given the workaround above and other priorities, we are unlikely to implement this idea at this time. We hope you can understand.