Forum Discussion
Solved
Pivot Table double sorting
Dear community, I am looking for a way to sort a pivot table with two criteria. First level: sort is done on Score column, this is working fine. Second level: sort should then be done on Sum of T...
It seems you can only sort by one value field.
As an alternative I used Power Query for filtering and sorting.
Thank You
pnriesen You tagged your original post "Excel on Mac". If you are on a Mac and not running Excel for Windows on a virtual machine, you may forget about Power Query. It's not supported by Excel for the Mac.
- I am on PC as well. However, working on both I would therefore need a solution which is compatible.