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.

Hierarchy settings

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

1. Header and Column

1.1. Category Highlight

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.

Cateory highlight

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.

Only on hover

Always Present

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.

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.

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

Data Volume

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.

Grand total title

3.2. Grand total height

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

The minimum and maximum values for grand total height are 5 and 45, respectively.

Grand Total Height

In this section, we covered the hierarchy display settings. Navigate to the next section to learn more about advanced number formatting.