Forum Discussion
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/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
It seems you can only sort by one value field.
As an alternative I used Power Query for filtering and sorting.
9 Replies
- Detlef_LewinSilver Contributor
Please review your text. It`s either "double filtering" or "double sorting".
And please share your file. Remove or change sensitive information.
- pnriesenCopper Contributor
Thank you for any help.
- Detlef_LewinSilver Contributor
It seems you can only sort by one value field.
As an alternative I used Power Query for filtering and sorting.
- pnriesenCopper Contributor
Title is changed. Simplified file is attached.