Row gripper

In this section, let's explore the various options in Inforiver to customize rows in your reports.

1. Insert

You can easily insert rows from the row gripper menu. Let's explore the different types of rows that can be inserted using this option.

Insert rows option

1.1. Add calculated row

Calculated rows allow you to create dynamic values based on formulas using other rows or measures in the report. They automatically recalculate when data changes. Learn more about calculated rows.

1.2. Add static row

Static rows are used to display fixed values or labels that do not change based on the underlying data. Learn more about static rows.

1.3. Add Break Row

Insert break rows to demarcate row categories. You can also apply formatting, such as setting the color for break rows.

1.4. Empty row

Financial statements and reports often require options to add white spaces for formatting. Inforiver provides the insert empty row option to achieve this in a single click. Learn more about empty rows.

2. Actions

The actions section has various formatting and customization options for rows. Let's take a detailed look.

Actions

2.1. Hide row

This option can be used to mask rows in the report. Note that hidden rows will still be included in total and sub-total calculations.

The Furniture category for the Consumer segment in the month of January has been masked using this option. Use the Show All Rows option from the row gripper to display the hidden rows.

2.2. Skip row

The skip rows option can be used when you need to effectively perform a soft delete on a row - the row will be excluded from totals and exports.

The Furniture category for the Consumer segment in the month of April (Quarter 2) has been removed using the Skip Row option, and the totals and sub-totals have been adjusted accordingly. This option can also be used to skip individual rows.

2.3. Skip and show row

This option will exclude the selected row category from totals and subtotals, but the row will still be displayed. The icon indicates that the row has been skipped.

Skip and show row