# Layout options

Plan offers two major types of layout options - **Table layouts** and **Measure layouts**. Each of these comes with its own set of variations and can be used together in a single layout.

The Table Layout lets you determine how categories in rows need to be displayed.

The Measure Layouts give you flexibility specifically with respect to how measures are displayed.

{% embed url="<https://lumel.wistia.com/medias/gqcymydbxw>" %}
Table and measure layouts - Overview
{% endembed %}

## 1. Table layouts

### a. Hierarchy

By default, Plan delivers data in a hierarchical, expand/collapse-enabled format.

When you select the Layout item from the menu, you will notice the selection defaulted to 'Hierarchy'.

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

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/inforiver-navigation-layout-hierarchy%20(1).png" alt=""><figcaption><p>Hierarchy layout</p></figcaption></figure>

Changing this selection helps you modify the report layouts to the other types listed below.

### b. Outline

The outline layout shows the row categories in individual columns.

By default, the 'ruler' is also enabled for this layout. The ruler is used to resize rows and columns easily, as you do in spreadsheets, and to select a specific column. You can hide the ruler by deselecting the ruler icon on the toolbar.

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

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/inforiver-navigation-layout-outline.png" alt=""><figcaption><p>Outline layout</p></figcaption></figure>

### c. Table

The table option shows categories in a tabular format, without any expand-collapse hierarchies for rows. Note that the hierarchy expand/collapse option is available for columns (Year-Quarter-Month).

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

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/2.2.2%20Layout%20options.png" alt=""><figcaption><p>Table layout</p></figcaption></figure>

### d. Stepped

The stepped layout is similar to the outline layout in that each category is listed in a column. The difference is in the availability of a separate total row for each branch of the hierarchy.

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

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/inforiver-navigation-layout-stepped.png" alt=""><figcaption><p>Stepped layout</p></figcaption></figure>

### e. Drilldown

The drill-down layout lets you explore one branch at a time in the hierarchy. This is also an ideal option when you have a huge volume of rows.

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

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/inforiver-navigation-layout-drilldown.gif" alt=""><figcaption><p>Drilldown layout</p></figcaption></figure>

### f. Tree

The tree layout helps you to customize the structure and display of your data, also helps you to visualize absolute and relative variances between the compared measures.

Go to **Home > Layout > Tree**. In the Configure Tree View pop-up select your baseline and Comparison measures and save.

<figure><img src="/files/74MK17A3uCVN5Kvp7BC2" alt=""><figcaption></figcaption></figure>

<p align="center"><sub>Configure Tree View pop-up.</sub></p>

After configuring the Tree View, click Save. The Tree View Option and its ribbon are added to the toolbar, which helps you in customizing your Tree view.

In the image below, we have COGS as the baseline compared with Gross Margin for all the quarters from the year 2023 to 2025.

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

<p align="center"><sub>Customized Tree View Layout</sub></p>

In the Tree View ribbon, we have various options to customise the tree layout. They are

* Timeline: You can select the timeline ranges for comparison between the measures.
* Quick Format: Lets you select the number scaling format.
* Baseline: Select your baseline measure.
* Comparison: Select the measure to be compared to the baseline.
* KPI: Select your Key Performance Indicators Measures.
* Create Scenario: You can easily create scenarios and simulate them. Click [Scenario ](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/scenario.md)to know more about it.

<figure><img src="/files/azJd5uH7INiPyyaHWugE" alt=""><figcaption><p>Scenario created in Tree Layout</p></figcaption></figure>

* Compare Scenario: Various scenarios created can be compared. Click [Compare Scenarios](/planning-sheets/how-tos/7.-planning-budgeting-and-forecasting/scenario/compare-scenarios.md) to know more about it.
* Display Settings: Under Display Settings, we have options to customize the tree layout's display.
* Node Customization: We can preview and customise the node scope, style, and components here.

<figure><img src="/files/cCqdRIZUURkNiphAhA65" alt=""><figcaption><p>Standard- Node Style</p></figcaption></figure>

<figure><img src="/files/EYq54OHavDsVMELJXDU4" alt=""><figcaption><p>Compact- Node Style</p></figcaption></figure>

<figure><img src="/files/V86gVK46UtRMatdngVrS" alt=""><figcaption><p>Custom-Node Style</p></figcaption></figure>

Under the Custom Node style, we can select the scope of the node

* Global: The Custom settings are applied to the entire report.
* Level: The custom settings are applied only to the particular level.
* Node: The custom settings are applied only to the particular node.

You can also do customisations by clicking on the pencil icon in the report. Each element in the tree layout can be customised to suit your needs.

* Level configuration: Here, node-level customization can be done.
* Appearance: Font color, main color, background color, and conditional formatting can be done.

<figure><img src="/files/al3EMm4WatDiTttzOSrI" alt=""><figcaption><p>Appearance- Display Settings</p></figcaption></figure>

## 2. Measure layouts

The default Measure layout is used in all the Table layouts listed above. You have two measure layout options. They are

* In Rows.
* In Columns.

The image below shows the various measure layout options

<figure><img src="/files/n8RGU69t6qmncmhSObei" alt=""><figcaption><p>Measure Layout options</p></figcaption></figure>

### a. In rows

When you change this to 'In rows', the measures are displayed as shown below.

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

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/inforiver-navigation-layout-measures-in-rows.png" alt=""><figcaption><p>Measure in rows</p></figcaption></figure>

To re-order rows while using the Measure in rows layout, you can click on the row gripper and drag the rows to be re-ordered. Click on the gripper and drag and drop the measures as desired.

You can view the hidden row dimension under the 'Manage Rows' options in your 'Measure on Rows layout'. You can unhide the row dimension by checking the box.

<figure><img src="/files/OJDw380ZThd590VuXz7O" alt=""><figcaption><p>The hidden dimension is displayed under the Manage Rows in the Measure on Rows Layout.</p></figcaption></figure>

### b. In columns

When you change this to 'In columns', the measures are displayed above the column hierarchy categories.

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

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/inforiver-navigation-layout-measures-in-columns.png" alt=""><figcaption><p>Measure in columns</p></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/layout-options.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.
