> 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/user-guide/3-create-your-first-planning-app/3-3-basic-interactions.md).

# 3.3 - Basic interactions

This module guides you through basic interactions in the planning sheet, including how to add sheets, configure layouts, manage hierarchies, and sort and filter data.

### Add planning, intelligence, and powertable sheets

1. Plan offers integrated planning, BI, and data management on a single app. Use the **Home** ribbon to add planning, intelligence, and powertable sheets.

<figure><img src="/files/6zWvk0UljtNEn7AEm5yk" alt=""><figcaption></figcaption></figure>

2. Select **New Planning Sheet** to create a new planning sheet.

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

3. Enter the sheet name and select **Create**.

<figure><img src="/files/9yNy12iwNTBaqu19Tsaj" alt=""><figcaption></figcaption></figure>

4. A new planning sheet is created.

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

5. Select **New PowerTable Sheet** to create a powertable sheet.

<figure><img src="/files/86c7WGgXSpEa6tBfQAzb" alt=""><figcaption></figcaption></figure>

6. Enter the powertable sheet name and select **Create**.

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

7. A powertable sheet is created.

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

8. Select **New Intelligence Sheet** to create an intelligence sheet.

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

9. Enter the intelligence sheet name and select **Create**.

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

10. A new intelligence sheet is created.

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

11. You can also select **New Page** and choose a sheet type to add more sheets.

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

### Configure layout options

1. Open the **Planning** ribbon to configure layout options.

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

2. Select **Layout** > **Hierarchy** to display child rows under parent rows.

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

3. Select **Table** to display a nonhierarchical table layout.

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

4. Select **Measures** > **In Rows** to display measures in rows instead of columns.

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

5. Select **Tree** to configure the tree layout.

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

6. Select baseline and comparison measures, and then select **Save**.

<figure><img src="/files/2HUOORhOIHZ9CzgW3RR1" alt=""><figcaption></figcaption></figure>

7. A new **Tree View** ribbon opens. You can now view business hierarchies in tree form.

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

### Manage hierarchies, totals, and subtotals

1. Select the **Expand/Collapse** icon in row and column headers to expand or collapse hierarchies.

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

2. Select the gripper menu beside a row header to access advanced expand and collapse actions.

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

3. Use the **Expand** or **Collapse** dropdowns to expand or collapse descendants, the entire level, or to expand/collapse all.

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

4. Use the **Totals** dropdown in the **Planning** ribbon to manage total and subtotal display.

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

5. Configure grand total and subtotal display settings from the dropdowns.

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

### Sort, reorder, and filter data

1. To reorder items, drag row and column headers with the gripper.

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

2. To configure sorting, select the gripper menu on the column header.

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

3. Use the **Sort** dropdown to select a sorting order.

<figure><img src="/files/78Biwjhr75f3dlsp8A0O" alt=""><figcaption></figcaption></figure>

4. Select the arrow on the sorted column to remove sorting.

<figure><img src="/files/2dKFjQI3HMkjV7vFz59U" alt=""><figcaption></figcaption></figure>

5. Select the **Filter** icon in the **Planning** ribbon to add and group visual-level filters. First, select **Add New Filter**.

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

6. Rename the filter, edit filter settings, add filter groups if necessary, and then select **Save**.

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

7. The filter is applied.

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


---

# 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/user-guide/3-create-your-first-planning-app/3-3-basic-interactions.md?ask=<question>&goal=<endgoal>
```

`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.
