By default, when you insert a PivotTable into an Excel workbook, the field list is shown in the order of the column headings in the original data set. I was working at a clientt site recently where there were numerous columns and we were unfamiliar with the data. Someone suggested it might be easier if we could see the field list in alphabetical order.
To achieve this, from the Pivot Table Tools Options tab at the left of the ribbon, click Options. The Options dialog box will be displayed. Go to the Display tab.
Towards the bottom in the Field List section, select Sort A to Z. Click OK. Your field list will now be shown in alphabetical order.