> For the complete documentation index, see [llms.txt](https://docs.ninox.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.ninox.com/builder-hub/visualize-and-organize-your-data/work-with-views/pivot-view.md).
# Pivot view
Use a Pivot view to group records and calculate summary values across rows and columns.
In **Pivot view** you can:
* Click **Configure pivot** to define how the pivot table is built.
* In **Rows**, choose the fields that should appear as row groups.
* The selected values appear in the first column of the pivot table.
* Add more than one row field if you want to break groups down further.
* In **Columns**, choose the fields that should appear as column groups.
* The selected values appear as column headers at the top of the pivot table.
* Add more than one column field if you want nested column groups.
* In **Values**, choose the fields you want to calculate.
* Select an aggregation such as **Sum**, **Count**, **Average**, **Min**, **Max**, or **Unique**, depending on the field type.
* For some field types, only specific aggregations are available.
* Add more than one value field to compare several results in the same pivot table.
* Use the arrow icons to change the order of row, column, or value fields.
* The order changes how the pivot table groups and displays the results.
* Remove a field if you no longer want to include it in the pivot table.
* Use [**Filter**](#filter-records-in-a-view) to show only the records you need in the pivot.
[Export data](/builder-hub/design-your-app/import-and-export-data/export-data.md) downloads the pivot as an Excel file with the rows and columns shown in the current view.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## 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, and the optional `goal` query parameter:
```
GET https://docs.ninox.com/builder-hub/visualize-and-organize-your-data/work-with-views/pivot-view.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
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.