Pivot tables
-
- UpdatedJan 30, 2025
- 7 minutes to read
- Yokohama
- Reporting
Pivot tables aggregate data from a table into columns and rows, which you define. They help you quickly investigate the source of the summarized data. Non-empty cells display tooltips to indicate how many records the cell represents. Click a non-empty cell to display a breakdown of those records.
You can configure a filter to refine the data further and select the aggregation values.

Create a pivot table
Create a pivot table to aggregate data from a table into columns and rows. Tooltips indicate what the values represent.
Before you begin
Role required: itil, report_user, report_group, report_global, report_admin, or admin. To create a meaningful report, you must have the right to access the data you want to report on.
About this task
Procedure
What to do next
- Select the Report info icon (
) and add a description of the report.
- Select the sharing icon (
) to open the Sharing menu. On this menu, you can add the report to a dashboard, export the report to PDF, publish the report to the web, and set visibility and schedules.
- Search the Community site for more insight or help with pivot reports.
Pivot report style options
Change the look of your pivot report.
When you create or edit a report, click the Style tab for options to configure the look of your report. The options are organized under two or more of the following tabs: General, Title, Legend, and Axis. To see how the report looks with the changed settings, click Save.
Field | Description |
---|---|
General | |
Drilldown view | List view to show when a user selects a segment of a report for which no
drilldown report type is specified. This view is also used when the user reaches
the lowest drilldown level of a report. See Configure the list
layout
. If you specify a Report
drilldown, Drilldown view is
ignored. For more information, see Define a report drilldown. |