Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.

Pivot tables

Log in to subscribe to topics and get notified when content changes.

Pivot tables

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 further refine the data and select the aggregation values.

Note: Pivot tables are no longer supported. If you have a problem with a pivot table report, open the report and change the type to Multilevel pivot table. The multilevel pivot table report is more stable and has more features than the pivot table.
Figure 1. Pivot table
pivot table example