Specifying Pivot View Columns
Use the Columns tab to customize the labels and order of data displayed in the pivot view.
Each row in this tab will be displayed as a column in the pivot view. The number of rows is determined by what is specified in X Axis and Categories in the Layout tab.
To customize the display of the pivot view:
-
In Label, enter the label that must be displayed for this column.
-
Select Sort to sort the pivot data by this column. Click the icon next to this option to sort in ascending or descending order.
-
Use the arrows on the right to change the order in which the columns are displayed. This list of columns are displayed from left to right in the pivot view.