# Pivot Table
## Introduction
The **Pivot Table** displays data in an interactive pivot table, where columns and rows can be collapsed to show individual data for sub-dimensions, as configured by the chart creator:
It also, optionally, displays the grand total values per row and column:
## Expected Data and Graph Designer
The Pivot Table doesn't expect data in a specific format, as the configuration of pivot tables is fully flexible. However, it is recommended to do any kind of data aggregation that you want to use in the pivot table, directly in the SQL query in order to increase performance.
In the Graph Designer you can then configure the pivot table in an Excel-like manner:
In the *Live Preview* you can also set number formatting options:
In the *Input parameters* section, you can configure whether the viewing user is able to export the pivot table as an XLSX, CSV, or PDF file and some additional viewing options:
## Exporting
Data can be exported as PDF, Excel or CSV:
---
# 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://docs.locoia.com/data-and-dashboards/dashboards-and-insights/charts/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.