Sorting Pivot Data
Pivot tables are very flexible and it is easy to sort data.
An alternative way to sort your data is to click the drop-down arrow beside the field in the pivot table
1. Click on the drop-down arrow beside Ship Via –(the Column Label at C4)
2. Click Sort A to Z and you will see the Products reorder themselves again.
3. Click the Undo icon so that the data is sorted in descending order again.
You can also use a custom sort that you have created however custom sorts are lost when you refresh a pivot table.