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.
Please review your text. It`s either "double filtering" or "double sorting".
And please share your file. Remove or change sensitive information.
Thank you for any help.
It seems you can only sort by one value field.
As an alternative I used Power Query for filtering and sorting.
- OK and thank you.
It looks like it works wit this method. How did you generate this new table with power query?
What is the principle? It works from the database or from the pivot table?
Can you quickly explain how to do it? Thanks
Title is changed. Simplified file is attached.
