Sort Pivot Tables based on multiple columns
I want to be able to sort various values I have selected in my Pivot table in addition to the rows and columns.
For example, in a pivot table representing code coverage, I have class and function as my rows, for my values I have lines of code and the percentage of code touched. In order to see where I should best focus my efforts, I want to see the functions with the most lines of code and the least code coverage, so I want to sort first by LoC (descending) and then by coverage percentage (ascending).
This doesn't appear to have the votes reflecting it, but this is a very common search. Several examples of this ask (since as early as 2014...):
There is also an additional UserVocie request on the Mac version:
Can we please get support for this across all versions of excel? This has been a popular ask for quite a while.