# Pivot

Pivot data lets you reorganize row dimensions to create alternate views of your data without changing the underlying dataset.

Each pivot view represents a unique arrangement of dimensions, enabling flexible analysis and planning across different perspectives.

With the **Pivot** option in the Planning sheet, you can:

* Reorder row dimensions
* Show or hide specific dimensions
* Create aggregated views using different dimension combinations

**Pivot Explorer** saves all pivot views, allowing you to quickly switch between them during analysis.

### Prerequisite

* Access to a Planning sheet with row dimensions configured.

### Create and use pivot views

1. Open your Planning sheet.
2. Select **Pivot**.

<figure><img src="/files/jQ7879Dy2SR1isTxNnXo" alt=""><figcaption></figcaption></figure>

3. select **Add**
4. Enter a name for the pivot view.
5. Select the required row dimensions.
6. Select **Save**.

<figure><img src="/files/ykQt7bUcevWgYJKerL1F" alt=""><figcaption></figcaption></figure>

The pivot view is added to the Pivot Explorer.

### Manage pivot views

Each pivot represents a unique combination of row dimensions.&#x20;

* Select your pivot view.

<figure><img src="/files/i3KMREOl7zEWJ9qy8H29" alt=""><figcaption></figcaption></figure>

The Pivot views can be managed by enabling the **Pivot Explorer**.

* Edit an existing pivot by updating its name or fields.
* Select (**⋮**) to **Duplicate** or **Delete** pivots.

<figure><img src="/files/ssxeWA1ClckD2SM4q1Wq" alt=""><figcaption></figcaption></figure>


---

# 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.fabricplan.com/planning-sheets/how-tos/pivot.md?ask=<question>
```

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.