Right click on the subtotal of any of the regions in the Grand Total column.Ĭlick Sort Largest to Smallest in the second dropdown list.

Likewise, if you want to sort the PivotTable on subtotals region wise, do the following − The subtotals in the Grand Total column are sorted from highest to lowest values, in every region. Right-click on the subtotal of any of the Salespersons in the Grand Total column.Īnother dropdown list appears with the sorting options – Sort Smallest to Largest, Sort Largest to Smallest and More Sort Options. You can still sort the PivotTable on subtotals as follows − You can see that there is no arrow for subtotals. That is, you want to sort the PivotTable on subtotals. Suppose you want to sort the PivotTable based on total order amount – highest to lowest in every Region. In the same way, you can sort the field in column – Month, by clicking on the arrow in the column labels. The Salesperson field will be sorted in descending order. The following sorting options are displayed −įurther, the Salesperson field is sorted in ascending order, by default. Select Salesperson in the Select Field box from the dropdown list. To sort the PivotTable with the field Salesperson, proceed as follows − You can sort the data in the above PivotTable on Fields that are in Rows or Columns – Region, Salesperson and Month. You can sort the data from lowest to highest values or highest to lowest values or in any other custom order that you choose.Ĭonsider the following PivotTable wherein you have the summarized sales data region-wise, salesperson-wise and month-wise. You can sort the data in a PivotTable so that it will be easy for you to find the items you want to analyze.

Add in custom sorting for excel on mac