How to Sort a Pivot Table by Values?

Click any cell in the PivotTable

Select the row or column label you want to sort

Right-click the label

Choose Sort

Select Sort Largest to Smallest or Sort Smallest to Largest

To sort by a specific value field, click the drop-down arrow next to the Row Labels or Column Labels

Choose More Sort Options

Select Ascending or Descending by the value field you want

Click OK

Refresh the PivotTable if the source data changes