Able to sort on aggregate values in cells in pivot tables

Who would benefit?

All users that view reports

What impact would it make?

Prevent exporting to Excel for simple aggregates

How should it work?

A user should be able to sort on the aggregated values in cells, like count, sum, etc. Apparently today, you can only sort on fields already in the data and not calculated in the report.

In reporting, often the value is in aggregating so this limits the usefulness of reporting greatly. The data would have to be exported to Excel, which doesn't look great to have to point everyone to Excel when we bought this new shiny product feedback tool