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.
Create a pivot report by opening the Pivot dialog from the Actions menu.
To create a pivot report:
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: