Sorting Value Area Fields in Excel Pivot Table

Question

I have created a Pivot Table with several columns and a "Count" value area field column. The Count column is the number of customers for that particular store. I would like to sort the entire table by the Count column to display the stores with the largest number of clients to the stores with the smallest number of clients. However, the value area field column header does not have a filter/sort drop down menu. I have not been successful in adding one either. If I right click on the cell with the count figure (say the number 53), I have a sort option. However, it seems to only sort those 53 customers by alphabetical order, rather than sort the entire pivot table by the number of customer in the count column. Can value area field columns being used to sort the entire pivot table? Is there a work around this? I know I can manually move the rows up and down. However, I'm dealing with huge amounts of data.

Answer 1

Hi,

Right click on any figure appearing in the Count column and go to Data > Z to A.