Pivot Tables Details and Sorting
The new Pivot Table feature to view details is helpful, but when the details have thousands of records, it beats the purpose of a Pivot Table.
Pivot Table Details should be able to be summarized just like it's parent pivot table so when we want to see details, we can see a few hundred rows rather than be stuck with the whole data table results.
also a sorting feature that can sort values A-Z even when there is a grouping on the table would be great. Pivot tables can be sorted by values ONLY if there aren't any groupings. This is useless if I want to sort the table to see the biggest result on a table of 100+ record groupings.
-
Anonymous commented
Enable sorting of grouped (SUM) values on the details page.