How to Sort in Pivot?

Click any cell inside the PivotTable

Open the drop-down arrow next to the Row Labels or Column Labels field

Select Sort A to Z or Sort Z to A

Right-click a row or column label

Choose Sort

Select Ascending or Descending

For custom sorting, drag the items manually if enabled

To sort by values, right-click a value in the PivotTable

Choose Sort

Select Largest to Smallest or Smallest to Largest

Use More Sort Options for advanced sorting

Refresh the PivotTable after changing source data if needed