SOLVED

Pivot Table double sorting

%3CLINGO-SUB%20id%3D%22lingo-sub-2879693%22%20slang%3D%22en-US%22%3EPivot%20Table%20double%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2879693%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20community%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20for%20a%20way%20to%20sort%20a%20pivot%20table%20with%20two%20criteria.%3C%2FP%3E%3CP%3EFirst%20level%3A%20sort%20is%20done%20on%20Score%20column%2C%20this%20is%20working%20fine.%3C%2FP%3E%3CP%3ESecond%20level%3A%20sort%20should%20then%20be%20done%20on%20Sum%20of%20T%2FP%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20other%20words%2C%20all%20License%2FName%2FSurname%20with%20score%2058%20should%20then%20be%20sorted%20by%20highest%20Sum%20of%20T%2FP%2C%20100%2C%20then%2097%2C%2096%20and%2093.%3C%2FP%3E%3CP%3EAny%20help%20available%20on%20double%20sorting%20in%20pivot%20table%20is%20highly%20appreciated.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2879693%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2879785%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20double%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2879785%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1194751%22%20target%3D%22_blank%22%3E%40pnriesen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20review%20your%20text.%20It%60s%20either%20%22double%20filtering%22%20or%20%22double%20sorting%22.%3C%2FP%3E%3CP%3EAnd%20please%20share%20your%20file.%20Remove%20or%20change%20sensitive%20information.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2879822%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20double%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2879822%22%20slang%3D%22en-US%22%3E%3CP%3ETitle%20is%20changed.%20Simplified%20file%20is%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2879826%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20double%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2879826%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20any%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2879847%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20double%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2879847%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1194751%22%20target%3D%22_blank%22%3E%40pnriesen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20you%20can%20only%20sort%20by%20one%20value%20field.%3C%2FP%3E%3CP%3EAs%20an%20alternative%20I%20used%20Power%20Query%20for%20filtering%20and%20sorting.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

 

 

9 Replies

@pnriesen 

Please review your text. It`s either "double filtering" or "double sorting".

And please share your file. Remove or change sensitive information.

Title is changed. Simplified file is attached.

Thank you for any help.

best response confirmed by allyreckerman (Microsoft)
Solution

@pnriesen 

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
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.