Configuring Rows

This article helps you understand various row functions and how to work with them for efficient calculation.

In this article, we will cover:

• Adding Row Expand

• Configuring Row Behaviour

• Adding Row Calculations

Adding Row Expand

1. In the Rows tab, select New > Expand.

   The New Expand widget displays.

2. Select a Dimension.

3. Configure hierarchy and members.

Configuring Row Behavior

Here you can:

• Show details (leaf levels).

• Show parents (aggregated values)

• Suppress zero rows

• Group rows

• Add total lines

Adding Row Calculations

1. Select New > Function.

2. Select calculation type (sum, subtract, etc.).

3. Select rows to include.

   Calculations use raw values and apply sign rules based on settings. If Sign Reversal is set to As shown, the calculated value is displayed without any changes. If set to Reversal, the value is displayed with the opposite sign.

   To learn more, review the article - Row Functions.

Editing, Removing and Duplicating Rows

1. Select the row you want to modify.

2. Choose one of the following actions:

   • Select Edit to modify the selected row.

   • Select Remove to delete the selected row.

   • Select Duplicate to create a copy of the selected row. The duplicated row displays directly below the original row.

3. If necessary, drag and drop rows to rearrange their order.

   If you remove a row and want to restore it, do not save the report. Close and reopen the report to discard the deletion.