# Hierarchy settings

In the Inforiver toolbar, navigate to the Home ribbon. Click **Settings > Display Settings** from the Actions section to open up the Display side panel.

Click on the **Hierarchy** tab in this panel to view the hierarchy settings. Let's explore the options to customize hierarchies in your reports.

<figure><img src="/files/fUNNhYRkkAcvrf7yFaad" alt=""><figcaption><p>Hierarchy settings</p></figcaption></figure>

Let's explore the options to customize hierarchies in your reports.

### 1. Header and Column

#### 1.1. Category Highlight&#x20;

This drop-down lets you show or hide the category highlight. This option is set to Off by default. When this option is enabled, a color picker is displayed. You can select a color to highlight the category hierarchy.

<figure><img src="/files/cc36uhiVfGPvdJ5zrgyv" alt=""><figcaption><p>Cateory highlight</p></figcaption></figure>

#### 1.2. Column gripper

This option controls the visibility of the olumn ripper. When set to nly on Hover, the olumn ripper appears only when you hover over a column. When set to Always Present, the olumn ripper is displayed at all times.

<figure><img src="/files/ZdrsKA7UjJcZAPbnNpIH" alt=""><figcaption><p>Only on hover</p></figcaption></figure>

<figure><img src="/files/4t1sb1hF0k2YmFbV2bDn" alt=""><figcaption><p>Always Present</p></figcaption></figure>

### 2. Data window

#### 2.1. Data Volume

Inforiver supports wide table use cases through the dynamic columns feature. You can fetch up to 1000 columns; however, the performance would be compromised. &#x20;

Every fetch from Power BI is 30,000 cells (Number of rows x Number of columns). This means you can load data chunks of different sizes dynamically - 500 Rows by 60 Columns (or) 30 Rows by 1000 Columns (or) 10,000 Rows by 3 Columns.&#x20;

You can adjust this volume to retrieve more data from the data source.

<figure><img src="/files/7PmpAca3DYngdqi9xizk" alt=""><figcaption><p>Data Volume</p></figcaption></figure>

### 3. Row totals

You can customize the grand total title and height here.

#### **3.1. Grand total title**

The options related to the grand total are displayed only if the Row Grand Total value has not been set to 'Off' under the Totals option.

You can set a custom title for the grand total in the textbox.

<figure><img src="/files/5xwuuLEYwi0H1jWmGX37" alt=""><figcaption><p>Grand total title</p></figcaption></figure>

#### 3.2. Grand total height&#x20;

The value that you specify here will override the default height of the grand total row.

{% hint style="info" %}
The minimum and maximum values for grand total height are 5 and 45, respectively.
{% endhint %}

<figure><img src="/files/c49dsRn6cUrG7wvunkXi" alt=""><figcaption><p>Grand Total Height</p></figcaption></figure>

In this section, we covered the hierarchy display settings. Navigate to the next section to learn more about [advanced number formatting](/premium-table/display-settings/number-settings.md).<br>


---

# 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.inforiver.com/premium-table/display-settings/hierarchy-settings.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.