> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/pivot-table.md).
# Use pivot table
## Pivot data in a planning sheet
Use *Pivot Table* to reorganize dimensions and measures and configure aggregations for totals and subtotals.
### Convert row dimensions and column dimensions
Move dimensions between the **Rows** and **Columns** buckets to change how data is displayed.
For example, convert the **Region** column dimension into a row dimension.
1. Open **Pivot Table**.
2. Drag **Region** from **Columns** to **Rows**.
The dimension is displayed as a row dimension instead of a column dimension.
### Configure measure aggregations
Configure aggregations for numeric measures when totals and subtotals are enabled.
Supported aggregation types include:
* Sum
* Average
* Minimum
* Maximum
1. Enable totals or subtotals.
2. Select the measure to aggregate.
3. Select an aggregation type.
For example, apply **Sum** to the **Profit** measure and **Average** to the **Sales** measure.
### Convert dimensions into measures
Convert a text dimension into a measure by moving it to the **Values** bucket.
1. Open **Pivot Table**.
2. Drag the dimension to **Values**.
The dimension is converted into a measure and can be aggregated with other values.
### Concatenate text values
Use **Concat** to combine text values from multiple rows into a single value by using a delimiter.
For example, concatenate all accounts within a segment while retaining the underlying information.
1. Drag the text field to the **Values** bucket.
2. Select **Concat** as the aggregation type.
3. Specify a delimiter.
The resulting value provides a summarized view of the underlying records and can be used in downstream visuals.
---
# 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.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/pivot-table.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.
