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.