This chart is deprecated. Please use the Pivot Table V2 chart instead.

​
Data Configuration

​
Rows

This section specifies the rows of the collapsible list. This section supports multiple fields. Additional fields will appear nested beneath the each value in the preceding field.

​
Aggregations

This section specifies the aggregated columns of the collapsible list. This section also supports multiple fields. Each field in this section will appear as a separate column in the collapsible list. Available aggregations for these sections include Count, Count Distinct, and Sum.

​
Filter

Read about the Filter section here.

​
Formatting

Read about the Header section here. Read about the Footer section here.

​
Show Categories

This toggle turns on category labels for each row in the first column of the collapsible list. In this section you can edit what the labels are in order to ensure they are human readable.

​
Category Column Title

This section specifies a column title for the first column header of the collapsible list.

​
Column Names

This section allows edits of the columns headers for the aggregation columns of the collapsible list.

​
Rows

This section contains formatting for the collapsible list categories, the values in the first column. Formatting for these cells is only available for numerical categories. There will be a carat by any rows that are numerical and therefore can be formatted. Read more about numerical formatting options here.

​
Columns

  • Sorting: This specifies if sorting is configurable. If sorting is toggled on, each category will appear in this section, and there will be a dropdown that can be used to specify which column to use for sorting for that category, as well as the sort order, ascending or descending.
This section also contains formatting for the collapsible list columns. Each column will appear with numerical formatting options. You can read more about the formatting options here.

​
No Data Configuration

Read about the No Data Configuration section here.