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.

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

When you select the More menu () in column header, you can Sort your Data, autosize your columns, 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.