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 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? ThanksThe Palmares table is imported into Power Query.
Import table into Power Query.
Filter a table in Power Query.
- Thank You