Oct 24 2021 05:59 PM - edited Oct 24 2021 07:21 PM
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/P column.
In other words, all License/Name/Surname with score 58 should then be sorted by highest Sum of T/P, 100, then 97, 96 and 93.
Any help available on double sorting in pivot table is highly appreciated.
Thanks
Oct 24 2021 06:59 PM
Please review your text. It`s either "double filtering" or "double sorting".
And please share your file. Remove or change sensitive information.
Oct 24 2021 07:11 PM - edited Oct 24 2021 07:21 PM
Title is changed. Simplified file is attached.
Oct 24 2021 07:20 PM - edited Oct 24 2021 07:22 PM
Thank you for any help.
Oct 24 2021 07:58 PM
SolutionIt seems you can only sort by one value field.
As an alternative I used Power Query for filtering and sorting.
Oct 24 2021 08:03 PM
Oct 24 2021 08:16 PM
The Palmares table is imported into Power Query.
Import table into Power Query.
Filter a table in Power Query.
Oct 24 2021 11:10 PM
@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.
Oct 24 2021 11:52 PM
Oct 24 2021 07:58 PM
SolutionIt seems you can only sort by one value field.
As an alternative I used Power Query for filtering and sorting.