Sort Data in Pivot Table by Column Descending Order

%3CLINGO-SUB%20id%3D%22lingo-sub-2058645%22%20slang%3D%22en-US%22%3ESort%20Data%20in%20Pivot%20Table%20by%20Column%20Descending%20Order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2058645%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20pivot%20table%20and%20I%20am%20trying%20to%20sort%20the%20information%20in%20it%20by%20a%20specific%20column.%20I%20am%20trying%20to%20sort%20the%20table%20by%20%22TOTAL%20REPS%22.%20I%20tried%20clicking%20on%20the%20%22Sort%22%20icon%20beside%20%22FORMATION%22%20then%20sorting%20the%20table%20in%20descending%20order%20by%20the%20%22TOTAL%20REPS%22%20column%2C%20but%20it%20gives%20me%20the%20same%20result%20of%20the%20orginal%20table.%20How%20can%20I%20sort%20my%20table%20by%20the%20%22TOTAL%20REPS%22%20column%20so%20that%20table%20is%20numerical%20sorted%20in%20descending%20order%20based%20on%20the%20%22TOTAL%20REPS%22%20value%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Excel%20PivTable%20Example.png%22%20style%3D%22width%3A%20444px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246249i2C14BF0295864F6D%2Fimage-dimensions%2F444x336%3Fv%3D1.0%22%20width%3D%22444%22%20height%3D%22336%22%20role%3D%22button%22%20title%3D%22Excel%20PivTable%20Example.png%22%20alt%3D%22Pivot%20table%20to%20sort%20by%20TOTAL%20REPS%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EPivot%20table%20to%20sort%20by%20TOTAL%20REPS%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Excel%20PivTable%20Example%202.png%22%20style%3D%22width%3A%20499px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246250i2681E6985C9A6E64%2Fimage-dimensions%2F499x492%3Fv%3D1.0%22%20width%3D%22499%22%20height%3D%22492%22%20role%3D%22button%22%20title%3D%22Excel%20PivTable%20Example%202.png%22%20alt%3D%22Excel%20PivTable%20Example%202.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2058645%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2058885%22%20slang%3D%22en-US%22%3ERe%3A%20Sort%20Data%20in%20Pivot%20Table%20by%20Column%20Descending%20Order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2058885%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F928295%22%20target%3D%22_blank%22%3E%40Jarrod_James%3C%2FA%3E%26nbsp%3BTry%20right-clicking%20inside%20one%20of%20the%20values%20in%20the%20TOTAL%20REPS%20column%20-%20that%20should%20provide%20a%20Sort%20option%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2059062%22%20slang%3D%22en-US%22%3ERe%3A%20Sort%20Data%20in%20Pivot%20Table%20by%20Column%20Descending%20Order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2059062%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F867265%22%20target%3D%22_blank%22%3E%40adversi%3C%2FA%3E%26nbsp%3B%20Thanks!%20This%20helped%2C%20but%20I%20still%20have%20to%20manually%20sort%20the%20particular%20values%20one%20subsection%20at%20a%20time.%20Is%20there%20a%20way%20for%20my%20entire%20table%20to%20sorted%20like%20that%20automatically%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi Everyone,

 

I created a pivot table and I am trying to sort the information in it by a specific column. I am trying to sort the table by "TOTAL REPS". I tried clicking on the "Sort" icon beside "FORMATION" then sorting the table in descending order by the "TOTAL REPS" column, but it gives me the same result of the orginal table. How can I sort my table by the "TOTAL REPS" column so that table is numerical sorted in descending order based on the "TOTAL REPS" value?

 

 
 

Pivot table to sort by TOTAL REPSPivot table to sort by TOTAL REPS

 

Excel PivTable Example 2.png

 
3 Replies

@Jarrod_James Try right-clicking inside one of the values in the TOTAL REPS column - that should provide a Sort option

@adversi  Thanks! This helped, but I still have to manually sort the particular values one subsection at a time. Is there a way for my entire table to sorted like that automatically?

@Jarrod_James Make sure you are right-clicking inside one of the values in the subcategory to control the sorting. If the problem persists, can you share the workbook, replacing any sensitive data that may exist.