# Data Tables

## Overview

Unlike Models, Excel will only calculate one [**Case**](/cases/introduction-to-cases.md) of your Model at a time, and you will need to use the [**Scenario and Sensitivity**](/cases/introduction-to-cases.md#how-scenarios-and-sensitivities-work-in-models) controls in your spreadsheet to change Case.

However, Excel [**Data Tables**](https://support.microsoft.com/en-us/office/calculate-multiple-results-by-using-a-data-table-e95e2487-6ca6-4413-ad12-77542a5ea50b) allow you to calculate results from different sets of inputs simultaneously, and display all results in one place. While this will not show you all outputs, it can be useful for comparing specific metrics over several Scenarios and Sensitivities, as shown in the example below.

<figure><img src="/files/7n7f90oGlGhpvDMutQKh" alt=""><figcaption><p>A <strong>Data Table</strong> in Excel, generated by Models</p></figcaption></figure>

{% hint style="info" %}
Due to the limitations of Excel Data Tables, which can only respond to a single input cell, when you add a Data Table to your Layout, Scenarios and Sensitivities are combined into a list of Cases that contains all combinations.

We also add a **Cases sheet** to the Layout, which contains the list of Cases. This sheet can be [**moved and hidden**](/layout/sheets.md#hide-sheet-in-excel) as desired.
{% endhint %}

## Creating a Data Table

To create a Data Table, simply go to the **Tables tab** of the [**Model Editor**](/models/model-editor.md) and add a new item. You will need to enter a name and choose which combinations of Cases to show.

{% hint style="info" %}
If you add new Scenarios and Sensitivities to the Model, these will not automatically appear in the Data Table. You will need to edit the selected Cases if you want them to be shown.
{% endhint %}

As shown in the screenshot below, once you have created the Data Table, you can edit it in the same way you [**edit a Sheet in the sheet preview**](/layout/sheets/adding-and-editing-content.md#adding-in-the-sheet-preview). In a Data Table, all sheet items are [**Metrics**](/metrics/metrics.md).

Use [**line formatting**](/layout/excel-formatting/line-formatting.md) and [**group spacing**](/layout/sheets/adding-and-editing-content.md#the-line-group-dialog) to change the appearance of your Table.

<figure><img src="/files/1WhOtdjYB773nvXzWYoz" alt="Screenshot of a Data Table in models."><figcaption><p>A <strong>Data Table</strong> in Models</p></figcaption></figure>

## Adding a Data Table to the Layout

To add a Data Table to the Layout, you must perform the following steps:

1. Add the Data Table to a [**Dashboard**](/dashboards/dashboards-basics.md). You must place the Data Table in the main [**Panel**](/dashboards/dashboard-layout.md) of the Dashboard, and the Data Table should be the only item in the Dashboard.
2. Add a Dashboard [**Sheet**](/layout/sheets.md) containing the Dashboard to the Layout


---

# 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://help.taglo.io/layout/data-tables.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.