Pivot
Aggregate the values in a table
Pivot takes a table and summarizes it, creating a new summary table based on the values of the source table.
Selection | Description |
Rows | The unique values of each selection will be displayed as the row headers of your Pivot table. If multiple options are selected, each unique combination of those selections are listed in the table. For example, if |
Columns (optional) | The unique values of each selection will be displayed as the column headers of your Pivot table. If a selection is made, the Pivot table columns will reflect the unique values of that selection. For example, selecting |
Values (optional) | The summarized values of each Values selection will appear in the body of the Pivot table. By default, the count of unique values is shown. If there is no selection made for Columns, each Values selection will appear as a column header. You may aggregate each Values selection with one of the following options:
|
Last updated