Remove sort order
Removing ascending or descending sort order will return the data either to its natural order, or if a custom order was specified, to the custom order.
- Click the Sort Ascending button or the Sort Descending button on the PivotTable list toolbar so that the button is not selected.