Pivot Table V2
Create complex pivot and collapsible list implementations
Data Configuration
Chart Type
You can read about this section here.
Rows
Define what Values are aggregated on. When multiple rows are specified, a collapsible list dropdown is automatically applied. An example input here could be ‘Salesperson Name’, which would create a row for each salesperson. Multiple rows could be ‘Region’ followed by ‘Salesperson Name’, which would create a collapsible list of regions and the salespeople within them.
Values
The values aggregated by Rows and Columns. An example input here could be ‘Sum’ on ‘Contract Value’.
Columns
Defines an additional parameter to calculate the Values on that shows up as columns in the table. For example, this could be ‘Month’ on ‘Contract Date’ to get columns for each month. For example, we could calculate total sales by salesperson by month by putting a ‘Month’ aggregation on ‘Contract Date’ in the columns section, ‘Salesperson Name’ in the rows, and ‘Sum’ on ‘Contract Value’ in the Values section.
It is possible to have multiple rows and multiple values
Filter
Read about the Filter section here.
Formatting
Header
Read about the Header section here.
Column Formatting
You can set the title of the aggregation for each Value.
Additionally, you may format the values. Read about the Value Formatting section here.
No Data Configuration
Read about the No Data Configuration section here.
Enable Download
Read about the Enable Download section here.
URL Link
Read about the URL Link section here.