> For the complete documentation index, see [llms.txt](https://docs.infotopics.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.infotopics.com/supertables/configuration/configuration-screen/data-tab/dimension-data-pane/dimension-properties.md).

# Dimension Properties

### Styles

Set the individual style of the Header and the Values in the table.

<figure><img src="https://content.gitbook.com/content/e2zyseN6XFBaLs6YTcnd/blobs/PLBfW1c366fNkX8eVvc3/Scherm%C2%ADafbeelding%202025-04-30%20om%2011.08.28.png" alt=""><figcaption></figcaption></figure>

### Hide column in sidebar

Sometimes you want to use columns in a calculation but not show them in the SuperTable. Enable the "Hide column in sidebar" option if you wish to hide the column from the sidebar so users cannot enable this column.

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2FtdPkJeh1amaVhHo2AICT%2Fimage.png?alt=media&amp;token=ef18d06e-b5de-45f2-a3f0-a901af636cec" alt=""><figcaption><p>Hiding a column in the sidebar</p></figcaption></figure>

### Hide header name

Enabling the "Hide header name" option this will remove the column header from the SuperTable view.

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2FAD9a6OGjEgUGuWKedAMv%2Fimage.png?alt=media&amp;token=1c439041-3bd3-479c-8b7a-3fd87943f9d4" alt=""><figcaption><p>Hiding a header name</p></figcaption></figure>

### Hide inline filter

Hide the filter option for a specific dimension in the Supertables views. You see in our example it’s not possible to filter on Order ID but possible on Product Name.&#x20;

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2FfHBx8Q2JFsCGBiq5ifvM%2Fimage.png?alt=media&amp;token=b5778327-ffb3-4d5d-a65d-78cd29e279d3" alt=""><figcaption><p>Hiding inline filters</p></figcaption></figure>

### Hide grand total

Hide the column total value. For instance you want to show the Sales total but not the quantity total in the total row of a grouped SuperTable, hide the total from your quantity column.&#x20;

### Show aggregated value when grouping

When grouping a dimension show the aggregated value of the members in the group. Decide what the default aggregation should be which includes Count and now CountD!

<figure><img src="https://appsfortableau.infotopics.com/wp-content/uploads/2022/09/SuperTables-Show-Aggregated-Value.gif" alt=""><figcaption></figcaption></figure>

### User can change aggregation method while grouping

<figure><img src="https://content.gitbook.com/content/e2zyseN6XFBaLs6YTcnd/blobs/WWL5t6cFErKf950XRj6W/image.png" alt=""><figcaption></figcaption></figure>

### Alignment

Choose the alignment of the text within your SuperTables view, as well as the header of the specific column.

### Header Tooltip

Change the tooltip of your selected dimension. By default, it will show the dimension name. This tooltip is for the column header only.

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2F5XvE10VjsFG0D82YnTTK%2Fimage.png?alt=media&amp;token=efc008d7-9ee4-444a-99b5-7f4b07947a99" alt=""><figcaption><p>Setting a custom header tooltip</p></figcaption></figure>

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2Fzbe0NeerZuq4c2bzIvDt%2Fimage.png?alt=media&amp;token=ad3fd50b-ce63-45c9-8abc-780da84e7c53" alt=""><figcaption><p>The custom header tooltip</p></figcaption></figure>

### Filter Style

***Multiple Values** (list)* – A dropdown to be able to show or hide values. The dropdown will contain all the values of the dimension.&#x20;

***Wildcard Match*** – The column will show a search bar for this column to be used as an inline filter.&#x20;

***Both -*** Both styles are applied.

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2FVmHqLAXjlbyAxJHZieOQ%2Fimage.png?alt=media&amp;token=1b5dd8ca-a292-40ec-9833-08ff6c396329" alt=""><figcaption><p>Filter style</p></figcaption></figure>

### URL Action

Entering a URL will allow users to click any cell in this column to open a new tab in their web browser. You can refer to any other value from the same row of data by wrapping the field name with angle brackets. You can of course also use a dynamically calculated field that contains a dynamic URL based on the content of that specific row of data. With this, you can set URL parameters to open a dashboard that has already been filtered on specific column values in your selection.&#x20;

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2FA6Wi71RjdkwFg1JWNJ4t%2Fimage.png?alt=media&amp;token=2e4ff65f-d471-49f6-a2ce-eae02b93585d" alt=""><figcaption></figcaption></figure>

### Conditional color formatting

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2Fp6fly4CNHVEsUBl5eSer%2Fimage.png?alt=media&amp;token=4d1d53df-1df4-4d0f-a161-175d3a47e0f4" alt=""><figcaption></figcaption></figure>

#### Color style

With this option, you can set conditional formatting. There are three options for conditional formatting:&#x20;

1. Change the font color of the cell&#x20;
2. Change the background color of the cell&#x20;
3. Change the background color of the entire row&#x20;

#### Background color

Use **Background color** to color rows based on specific dimension values.

To configure this:

1. Open **Format Extension**
2. Go to the **Data** tab
3. Select the relevant **dimension**
4. Scroll down to **Background color**
5. Define the value and the color you want to apply
6. Enable **Use color as background color of entire row** if the color should be applied to the full row instead of only the selected cell

This setting can be used when you want specific values in a dimension to drive row-level highlighting.

<figure><img src="https://1304574535-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe2zyseN6XFBaLs6YTcnd%2Fuploads%2FcbcMRvVZIS60uM7sfIvh%2Fbackground.gif?alt=media&amp;token=1a419a38-493a-4bac-ad40-dc4c3c89e480" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Please note that you cannot configure colors for a dimension with more than 50 members. &#x20;
{% endhint %}


---

# 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 by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.infotopics.com/supertables/configuration/configuration-screen/data-tab/dimension-data-pane/dimension-properties.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
