Pivot tabel order data not working

%3CLINGO-SUB%20id%3D%22lingo-sub-1516465%22%20slang%3D%22en-US%22%3EPivot%20tabel%20order%20data%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516465%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20pivot%20table%20in%20format%20table%20with%2010%20columns%20of%20data.%20I%20would%20like%20to%20order%20the%207th%20column%20from%20A%20to%20Z%2C%20or%20if%20possible%20with%20a%20custom%20order.%20If%20I%20order%20it%20from%20A%20to%20Z%20nothing%20appens.%20If%20I%20do%20the%20same%20to%20the%20first%20and%20the%20second%20column%20it%20works%20instead.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20know%20any%20solutions%20to%20order%20from%20A%20to%20Z%20a%20column%20which%20is%20not%20in%20the%20first%20positions%20(e.g.%20first%20or%20second)%2C%20and%20if%20possible%20do%20you%20know%20how%20to%20order%20it%20in%20a%20custom%20way%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot%2C%3C%2FP%3E%3CP%3EAlessandro%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1516465%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516492%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tabel%20order%20data%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516492%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F648182%22%20target%3D%22_blank%22%3E%40alepado%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorting%20on%20columns%20from%20the%20rows%20area%20works%20only%20within%20the%20scope%20of%20the%20previous%20column.%3C%2FP%3E%3CP%3EAs%20you%20already%20found%20out%20you%20have%20to%20move%20the%20column%20to%20the%20first%20position%20to%20get%20the%20%22full%20experience%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516498%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20tabel%20order%20data%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516498%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%20thank%20you%20for%20the%20quick%20reply.%3C%2FLINGO-BODY%3E
New Contributor

Hello all,

 

I have a pivot table in format table with 10 columns of data. I would like to order the 7th column from A to Z, or if possible with a custom order. If I order it from A to Z nothing appens. If I do the same to the first and the second column it works instead.

 

Do you know any solutions to order from A to Z a column which is not in the first positions (e.g. first or second), and if possible do you know how to order it in a custom way ?

 

Thanks a lot,

Alessandro 

2 Replies

@alepado 

Sorting on columns from the rows area works only within the scope of the previous column.

As you already found out you have to move the column to the first position to get the "full experience".

 

@Detlef Lewin thank you for the quick reply.