# Row gripper

### 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.

<figure><img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2Fnvaxv9A88ZMdZgxlHFOB%2Fimage.png?alt=media&#x26;token=7e8ce5b0-4a45-408e-9475-c2554f905339" alt=""><figcaption><p>Insert rows option</p></figcaption></figure>

#### 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.](https://docs.inforiver.com/premium-table/working-with-premium-table/4.-adding-business-logic-and-formulae/insert-calculated-rows)&#x20;

#### 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.](https://docs.inforiver.com/premium-table/working-with-premium-table/4.-adding-business-logic-and-formulae/insert-manual-input-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](https://docs.inforiver.com/premium-table/working-with-premium-table/2.-displaying-information/basic-formatting/insert-blank-rows).

### 2. Actions

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

<figure><img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FpGDHLwujeuG4UY6q7cob%2Fimage.png?alt=media&#x26;token=5e856030-0905-46e8-af52-d6f44c38c53c" alt=""><figcaption><p>Actions</p></figcaption></figure>

#### 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.

<figure><img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FEYJZEDAxLtrrlO3Qn6Tw%2Fimage.png?alt=media&#x26;token=10a031b2-251a-418a-bad1-cca4b8c5339d" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FRfBxnQt7hLehkxsYYgCQ%2Fimage.png?alt=media&#x26;token=99bb396f-c9a3-49e2-82f1-fec893d72980" alt=""><figcaption></figcaption></figure>

#### 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.

<figure><img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FzU0AhnNKqnQXwOHh7sk1%2Fimage.png?alt=media&#x26;token=c97683aa-95b4-4d7d-b7ca-2dacf37bf063" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FQroolkFIeCxEZoW3fw2w%2Fimage.png?alt=media&#x26;token=6e370688-eb41-4423-af66-2025f7a664de" alt=""><figcaption></figcaption></figure>

#### 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 <img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/8Wgs9hRMdxUiKXcvq1yk/image.png" alt="" data-size="line">icon indicates that the row has been skipped.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/1i2e14HahMrDL9yJRBxc/image.png" alt=""><figcaption><p>Skip and show row</p></figcaption></figure>
