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 {City} and {State} are both selected as Rows, the table will list each unique City-State pair.
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 {State} will list every unique State in the original table. Max 1,000 columns.
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: Count: Number of non-null values (can be used on text columns) Sum: Numeric total Min: Minimum value Max: Maximum value Std_dev: Standard deviation of values CountD: Count of distinct values (can be used on text columns)