Pivot

1 Minute to read

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

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

In Practice: Pivot

Click the Pivot icon and select Pivot.
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.

Note:

If only one dimension is available on the row/ column, it cannot be pivoted to the Page, as we need at least one dimension on the row and column.

In Practice: Pivot to Page

Select a dimension on a row or column and navigate to Pivot > Pivot to Page.
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.

Note:

If only one dimension is available on a column, it cannot be pivoted to a row, as we need at least one dimension on the column.

In Practice: Pivot to Row

Select a dimension from the column, and navigate to Pivot > Pivot to Row.
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.

Note:

If only one dimension is available on the row, it cannot be pivoted to the column, as we need at least one dimension on the row.

In Practice: Pivot to Column

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

Was this article helpful?

What's Next

Keep Only, Remove Only & Get Data

Table of contents