# Tree view

The Planning sheet provides a **Tree layout** that lets you visualize the model in a hierarchical tree structure, run simulations on the fly, and view results as sparkline charts within nodes.

Simulations help businesses make informed decisions by testing out different scenarios and seeing the results. With tree view, you can create and compare multiple scenarios, perform in-depth scenario analysis, and visualize them.

### Advantages of tree view

* Create and compare multiple scenarios.
* Simulate changes on the fly and perform what-if analysis.
* Identify key performance drivers through simulation.
* Assign important nodes as KPIs or key inputs to track progress.
* Evaluate performance against a benchmark.
* Add comments and collaborate with your team.

### Tree view overview

When you select **Layout > Tree view** and choose the baseline and comparison series, the model is displayed in a tree view layout.

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

The tree is presented in a horizontal format as a visual. Its structure begins with a single node called the top node/root node, and this node then branches out to other nodes as children/descendants. In the image below, the model is segmented into levels starting from level 1 with the top node named 'Net Profit'. The nodes share a parent-child relationship at each level.&#x20;

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

### Navigate through tree view

You can traverse through the nodes using the mouse scroll or by dragging and dropping the hand tool on the canvas. Use **Ctrl +** and **Ctrl -** to zoom in and out.

* Select **>** to expand and **<** to collapse levels.&#x20;
* Use **Go to level** to navigate between different levels.
* Select the **Zoom** icons to zoom in/out of the canvas as well as to reset zoom.
* Use **Node Customization** to customize the text and chart alignment on nodes.

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

### Compare baseline and comparison series

The tree view that includes comparison series displays nodes with variance values obtained by comparing both series.&#x20;

Nodes in green indicate that the variance is favorable based on the desired trend you set. For example, a positive variance is favorable when the desired trend is increasing, while a negative variance is favorable when the desired trend is decreasing. Unfavorable variances are shown in red. You can also format them to appear in orange or other colors depending on the variance.

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

### Understanding node components

<figure><img src="/files/5AAmcezHIMPKCFrtjGre" alt=""><figcaption></figcaption></figure>

<table><thead><tr><th width="235.25">Component</th><th>Description</th><th>Corresponding item in the image</th></tr></thead><tbody><tr><td>Node name</td><td>Every node is identified by its name, which can be a value driver, KPI, or category name.</td><td><em>Net Profit</em></td></tr><tr><td>Node value</td><td>The primary value in the node is the baseline value, which represents the total of the node's baseline series. On a simulated node, this value represents the simulated value.</td><td><em>225.95k</em></td></tr><tr><td>Comparison value</td><td>The value series used for comparison that appears when you hover over the sparkline chart.</td><td><em>230.37k</em></td></tr><tr><td>Absolute variance</td><td>Absolute variance is the difference between the Baseline and Comparison series in absolute numbers. On a simulated node, it represents the difference between the simulated series and Comparison series in absolute numbers.</td><td><em>-4.42k</em></td></tr><tr><td>Percentage variance</td><td>Percentage variance is the difference between the Baseline and Comparison series in percentage terms. On a simulated node, it represents the difference between the simulated series and Comparison series in percentage terms.</td><td><em>-1.92%</em></td></tr><tr><td>Sparkline chart</td><td>A sparkline chart is available on each node to show the trend. During simulation, the chart updates dynamically to display the new trendline as a solid line and the previous trendline as a dotted line.</td><td><img src="/files/2eYv17XZ31rGS8sHIEGF" alt="" data-size="original"></td></tr><tr><td>Conditional formatting</td><td>A color band is displayed at the bottom of the node to indicate whether the value or variance is favorable or unfavorable (as configured in the node settings for that node).</td><td><em>orange bar below the node</em></td></tr><tr><td>Simulation-disabled icon</td><td>This symbol on a node indicates that simulation is disabled and the node value cannot be simulated. </td><td><img src="/files/Ct5JZQlQzx90YnoDREwc" alt="" data-size="line"></td></tr><tr><td>Add comment</td><td>Select this to add a comment to a node and collaborate.</td><td><img src="/files/674783CUduk5CaUMCieK" alt="" data-size="line"></td></tr><tr><td>Node options</td><td>Use this context menu to change node settings and lock/unlock the node for simulation.</td><td><img src="/files/HNuS8bGNXNoJZlmzZY3d" alt="" data-size="line"></td></tr></tbody></table>

### Node settings and configuration


---

# 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/tree-view.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.
