Pivot reports transpose rows into columns to generate results in a crosstab format.
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.
Parent topic: Customizing an Interactive Report Using the Actions Menu
Create a pivot report by opening the Pivot dialog from the Actions menu.
To create a pivot report:
Select a function, column, label, and format mask.
To create a sum, click the Sum check box (optional).
The Search Bar now contains two icons: View Report and View Pivot. Click these icons to toggle between the report view and the pivot view.
The following example shows a Pivot report that displays the number of closed, on-hold, open, and pending tasks associated with each project.
Edit a pivot report by clicking the Edit Pivot filter in an interactive report and opening the Pivot dialog.
To edit a pivot report:
Remove a pivot report from an interactive report in the Pivot dialog.
To delete a pivot report:
You can also click the Remove Pivot icon to the right of the Edit Pivot filter.