A pivot report transposes rows into columns to generate results in a crosstab format. You select pivot columns and rows and then provide the functions to be represented in the pivot report. Once created, pivot reports display a new icon in the search bar.
Create pivot reports
-
Select Actions > Format > Pivot to open the Pivot dialog.
-
Select the columns to display in Pivot Columns. To add additional columns, click Add Pivot Column.
-
Select the rows to display in Row Columns. To add additional columns, click Add Row Column.
-
For computation, select a function and a column, define a label and a format mask. To create a sum, select the Sum check box (optional). To add additional functions, click Add Function.
If you do not enter a label, the report displays the internal item name.
-
Click Apply.
-
You can use the buttons next to the Actions box to toggle between the pivot and the report view.
Edit pivot reports
-
Click Edit Pivot.
The Pivot dialog appears.
-
Edit the attributes.
-
To remove a previously defined column or row, select the default setting, Select Pivot Column and Select Row Column.
-
Click Apply.
Delete pivot reports
-
Click Edit Pivot.
The Pivot dialog appears.
-
Click Delete.
You can also click the Remove Pivot icon to the right of Edit Pivot.