# Pivot Table
## Overview
* Pivot Table is a powerful tool used in data analysis and business intelligence.
* Like Microsoft Excel, it helps in extracting significance from a large, detailed data set by allowing the users to rearrange and aggregate data with a simple drag-and-drop interface.
* By organizing and grouping the data, Pivot Table facilitates the identification of patterns and insights, making it an invaluable feature for anyone looking to analyze trends, comparisons, and patterns in their data.
* First, click on any "+ Add widget" button to add a widget.
* Click on the Pivot Table option.
* Click on the Add widget button to proceed.
* Choose the available Collection or Connection of the data model that has been added.
## Set up your Pivot Table
* The Pivot table shall be in Grouped mode as default.
### Add Columns
* Click on the Columns box.
* The All fields pop-up will appear with all the available columns of the data model.
* Simply drag and drop one or many fields into the Columns.
* You can also drag and drop the fields to Rows and Values.
{% hint style="info" %}
You can not select again the fields you have used for Rows and Values.
{% endhint %}
* Click the Done button and the X button to close the All fields pop-up.
### Add Rows
* Click on the Rows box.
* The All fields pop-up will appear with all the available columns of the data model.
* Simply drag and drop one or many fields into the Rows.
* You can also drag and drop the fields to Columns and Values.
{% hint style="warning" %}
You can not select again the fields you have used for Columns and Values.
{% endhint %}
* Click the Done button and the X button to close the All fields pop-up.
### Add Values
* Click on the Values box.
* The All fields pop-up will appear with all the available columns of the data model.
* Simply drag and drop one or many fields into the Values.
* You can also drag and drop the fields to Columns and Rows.
{% hint style="warning" %}
You can not select again the fields you have used for Columns and Rows.
{% endhint %}
* Choose the [Formula](/docs/dashboard/footer-formula.md) to display your desired metric.
{% hint style="info" %}
The default formula is Sum.
{% endhint %}
* You can click on the 🖊 icon to [customize](/docs/dashboard/custom-column-configuration.md) the selected Values.
* You can also customize the selected Values by clicking on the 🖊 icon in the Pivot table.
***
{% hint style="info" %}
To create a Pivot table, you only need to add Columns or Rows with Values.
{% endhint %}
## Apply your selections
* Your Pivot Table setup has been completed.
* Click the Save changes button to confirm your setup.
{% hint style="info" %}
* You can build the Pivot Table with just only Columns or Rows with Values.
* Use the search bar in the All fields pop-up to find your desired columns.
{% endhint %}
## Grand Totals
* Toggle this on if you want to see the Grand totals.
## Add more or change fields
* To add more new fields in any section, first, click on the See more button.
* Click on the Add field button then begin to drag and drop the available field to your desired section.
* To move a field to another section, simply click and hold then move that field.
## Clean fields
* To clean a field, click on the X button right next to it.
* To quickly clean all the fields in a section, click the Clear all button in the See more menu.
## Quickly Expand and Collapse
* If you have multiple rows, it will add the same as Grouping Table.
* You can quickly expand/collapse the whole group or just a sub-group by clicking the button and then choosing.
* The state of expansion/collapse will be saved on each device.
***
## Change to the Pivot Table type from another widget
* The Pivot Table option can be selected by opening the Settings slider and then clicking on the Properties option.
* Click on the View type dropdown and choose the Pivot Table icon to begin configuring your data model to the Pivot Table.
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://endash-guidance-docs.gitbook.io/docs/dashboard/widget-types/pivot-table.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.