Pivot

The Pivot feature helps you to swap the dimensions between page, row, and column by defining the view as required.

In Practice: Pivot

1. Click the Pivot  icon and select Pivot.
   
2. The column data is swapped to a row, and the row data is swapped to the column. 

Before Pivot

After Pivot

Pivot to Page

Pivot dimensions to the page level help you to pivot a dimension from a row to a Page section or from a column to a Page section.

In Practice: Pivot to Page

1. Select a dimension on a row or column and navigate to Pivot > Pivot to Page.
   
2. The selected dimension is swapped to the page level.
   

Pivot to Row

With Pivot to Row, you can select a single dimension and pivot it from the column to the row or from page to row. Dimensions not selected remain on the column/page, respectively. 

In Practice: Pivot to Row

1. Select a dimension from the column, and navigate to Pivot > Pivot to Row.
   
2.  The selected dimension is swapped from column to row.
   

Pivot to Column

With Pivot to Column, you can select a single dimension and pivot it from a row to a column or from page to column. Dimensions not selected remain on the row/page, respectively.

In Practice: Pivot to Column

1. Select a dimension on the row from the view, and navigate to Pivot > Pivot to Column.
   
2. The selected dimension is swapped from row to column.