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.
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.
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.
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.
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.
3.2. Grand total height
The value that you specify here will override the default height of the grand total row.
In this section, we covered the hierarchy display settings. Navigate to the next section to learn more about advanced number formatting.
Last updated
Was this helpful?