---
title: "Configure pivot table view settings"
slug: "configure-pivot-table-view-settings"
abstract: "How to display search results in a pivot table view, allowing statistical analysis and insightful aggregation."
---
# Configure pivot table view settings

You can [configure a pivot table view](https://doc.sitecore.com/ch/en/users/content-hub/views.html#UUID-483fea56-8058-cee5-20e3-2d668bfa8b91_N1708001639330 "Pivot table") so that it displays search results as a statistics chart that summarizes the data and provides insightful aggregations. It offers several visualization types (area chart, bar chart, heat map, and so on) and several aggregations (balance, first, maximum, and so on).

## Fields

To add a field to the pivot table:

1. In the **Field** section, click **Add** :mdiPlus:.
2. Configure the following parameters:

    | Field | Type | Description | Value | Mandatory |
    | --- | --- | --- | --- | --- |
    | **Field** | Drop-down list | Defines a table field. | List of available fields. | Yes |
    | **Position** | Radio buttons | Sets the field position. | **None / Row / Column** | Yes |

3. Click **Save**.

## Visualization

To configure the pivot table visualization:

1. In the **Visualization** zone, click **Add** :mdiPlus:.
2. In the **Type** drop-down list, select an option.
3. To enable the desired aggregation, click the applicable switch to turn it on.
4. If you configured several aggregations, select **Default** next to an aggregation to set it as the default aggregation.
5. Click **Save**.

## Aggregations

After selecting a visualization, you can enable one or multiple aggregations by using the switches. You can also select an aggregation as default.

The following table of fields provides the basis for aggregation.

| Aggregations | Number of fields required | Description |
| --- | --- | --- |
| **Average** | One field | Aggregate refers to the total sum of elements in a data set. |
| **Balance** | One field | Balance is the sum of data, with cost expressed as a negative value and budget as a positive. |
| **Count** | No field | Count is the total number of data points. |
| **Maximum** | One field | The maximum value of all data points. |
| **Median** | One field | The middle value of all data points. |
| **Minimum** | One field | The minimum value of all data points. |
| **Sum** | One field | The sum of the data points. |

> [!note]
> For information on how to display a budget as a pivot table, see [Display the budget as a pivot table](https://doc.sitecore.com/ch/en/users/content-hub/display-the-budget-as-a-pivot-table.html "Display the budget as a pivot table").