# 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="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FPzoW3bjb7DnFTC3q3lep%2Fimage.png?alt=media&#x26;token=f8f9cdfa-2c6c-41a0-a4f2-8c02a96f9ea9" 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="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FjrPaPwgFfFZtCJCGTURF%2Fimage.png?alt=media&#x26;token=95d94546-eb3f-440b-a7b5-4f0e2e0185a3" 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="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2F16PdgjyJ3fAKsCRzis0J%2Fonly%20on%20hover.gif?alt=media&#x26;token=cf5d3d14-42fe-4f9d-a925-7e0517aecf1d" alt=""><figcaption><p>Only on hover</p></figcaption></figure>

<figure><img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FFgeWSRtmvNfoJ8No9UIK%2Fimage.png?alt=media&#x26;token=8d13de96-1564-4306-b37b-3f0e3c0ebc3b" 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="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FGCvCwZfAXSVeV67FxiKv%2Fimage.png?alt=media&#x26;token=1d855a08-4abf-47b9-b176-fa0953caed62" 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="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2F3CP1OgmNn7j488SAXszP%2Fimage.png?alt=media&#x26;token=48bd9958-b295-4983-b5bd-1c8682e0ed7a" 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="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FVTV5KUPFfAgAPPUrkqgv%2Fimage.png?alt=media&#x26;token=141801b5-0725-4ee3-89bd-8a9116cef299" 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](https://docs.inforiver.com/premium-table/display-settings/number-settings).<br>