Sort on multiple columns in a pivot table. I can now only sort on one column
Suppose you want to sort on the second column from largest to smalles. And values in the first column (if they have the same value in the second column) you want to sort alphabetically. I can't find a way to do this in Excel for Mac.
Sort columns by date oldest first , alphabetize name and the dollar amount in the 3rd column must appear with the name
John Connor Greene Knudson commented
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...):
Can we please get support for this across all versions of excel?