Pivot Tables

Pivot tables are tables of summarized statistics. They are useful for finding unique values for a field. If needed, you can add custom metrics to your pivot table metrics.

Pivot tables are supported by all Composer data connectors except Cloudera Search. They are supported by Composer Apache Solr connectors for version 5.2 or later.

When you select a table metric, the context menu appears. See Use the Context Menu.

When you select the table context menu () in a column header, you can sort your data, autosize your columns, show or hide metric labels, and collapse or expand all rows for hierarchies.

After you create a pivot table, you can alter the rows, columns, metrics and metric layouts, and horizontal scroll bar used in a pivot table. In addition, you can sort the data in the table and rearrange the table fields. See the following topics:

• Configure Settings for a Specific Pivot Table

• Modify Pivot Table Rows

• Modify Pivot Table Columns and Column Widths

• Modify Pivot Table Metrics and Metric Layout

• Rearrange Pivot Table Fields

• Sort Data in a Pivot Table

Note: You can use Keyboard Controls on the Pivot Table sidebar instead of a mouse.