I make extensive use of Summary reports and Pivot Tables.

Most of these reports are structured such that I have several columns of "information" data that I want displayed, followed by one or more "Data" summarizations.

For example, I have the following report:

However, once created, it is impossible to sort the table by anything other than "School Name", the first column in the final report. I assume because it is only sorting by the "group by" (in order), but that makes the report basically useless because there is always only one row in each group.

We want/need our end-users to be able to specify their given User Filters to narrow down to the relevant rows, then sort those by any column they wish.

There does not seem to be any way to structure either summary or pivot tables in such a way that the end-user can actually sort the finished product by any given column - which is how any spreadsheet or other data reporting system would work (and what the user would expect).

The only way around this is to manually create my entire summarization via query tables, then display the data via a "tabular" report, which is extremely time-consuming and counter-intuitive for our data team.