> ## Documentation Index
> Fetch the complete documentation index at: https://docs.explo.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Pivot Table

## Data Configuration

#### Columns

The field in this section will populate the column headers of the pivot table.

#### Rows

The field in this section will populate the first column of the pivot table.

#### Pivot Value

This section is for the field you wish to aggregate the pivot table on, as well as the type of aggregation.
The default aggregation is `Sum` for numerical values or `Count` for all other values.

#### Join with another dataset

This section allows you to select another table entirely to generate the column names for your
table. Select "Join with another dataset" and choose a dataset and column to
configure this behavior.

#### Filter

Read about the `Filter` section [here](/creating-dashboards/visualizations/data-tab#filter).

## Formatting

Most of the formatting options for pivot tables are shared with the data table visualization. Read more about these options
[here](/creating-dashboards/visualizations/charts/data-table#formatting). Below are the formatting options
specific to pivot tables.

#### Rows

* **Display Sum Row:** This will create a row at the top of the pivot table aggregating all the values in each column.
* **Sum Row Label:** This is the label for the sum row, in the first row of the first column of the pivot table.
* **Bold Sum Row:** This option bolds all of the values in the sum row.
* **Sum Row Background Color:** This option sets a background color for the sum row. By default, this is white.

#### Columns

## Column Names

* **String Format:** This section can be used to specify a format for the column headers.
* **Remove Underscores:** This section can be used to remove underscores from the column headers.
* **First Column Name:** This section can be used to edit the header of the first column.