Forum Discussion
Sort Data in Pivot Table by Column Descending Order
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 ...
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.