Show/hide values

Inforiver allows you to hide/unhide cells, rows, columns or measures from the toolbar in a single click.

1. Cells

a) To hide a cell, click on the cell and then the hide icon highlighted.

Hiding a cell

b) The cell gets hidden. You can also see that the hide icon is highlighted to indicate that the cell has been hidden. Formatting options are also greyed out in the 'Style' and 'Alignment' sections.

Cell hidden

c) You can hide multiple cells or cell ranges in a single click. Use Ctrl/Shift and click to select non-adjacent or adjacent cells.

Hiding multiple cells

d) To unhide, select the cell(s) and click on the unhide option.

Unhiding cells

2. Rows

a) To hide a row or multiple rows, make a selection and click on the hide icon.

Hiding a row

b) To unhide, click on the 'Show/hide' dropdown -> 'Rows' -> 'Unhide'.

Unhiding a row

c) Multiple rows can be hidden at a time.

Hiding multiple rows

d) When multiple rows are hidden, you can choose to unhide selected rows as required.

Unhide selected row(s)

3. Columns

In this example, we have sub-categories in the column field. Let's say you want to hide Juices -> 2021 Actuals alone. This can be achieved using 'Show/hide columns'.

a) Select the column and click on the 'Hide' icon.

Hiding a column

b) The column gets hidden.

Unhiding a column

c) You can also hide individual columns from the column gripper as shown below.

Hiding a column from the column gripper

d) Multiple columns can be hidden by using Shift/Ctrl + click.

Hiding multiple columns

4. Measures

In this example, we have sub-categories in the column field. Let's say you want to hide 2021 Actuals for all the sub-categories. This can be achieved using 'Manage columns'.

a) Click on the 'Manage columns' dropdown. A list of the row hierarchies and the measures is displayed. To hide 2021 Actuals, uncheck the highlighted checkbox.

Hiding column

b) 2021 Actuals are hidden.

Hiding a measure

c) To show a measure, check the corresponding checkbox.

Unhiding a measure

5. Measure headers and category headers

You can select the measure header and click on the hide icon if you do not want to display headers in your reports. Repeat the procedure to display a hidden measure/category header again.

Hiding measure headers

6. Displaying hidden/skipped rows

To enable hidden or skipped rows, navigate to the Show/hide dropdown > Rows section and click on the respective icon to display the row again in your report.

Displaying hidden rows

In the next section, we'll cover how to manage column widths.