Question:  How do I sort the pivot table results?

Answer:  Select the row heading that you wish to sort on. Right-click and then select "Field Settings" from the popup menu. In this example, we've selected the row heading called Order ID.

When the PivotTable Field window appears, click on the Advanced button.

Under the AutoSort options, select either Ascending or Descending depending on the sort order that you wish to select. Click on the OK button. In this case, we've chosen to sort the Order ID field in ascending order.

This will return you to the PivotTable Field window. Click on the OK button.