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.

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.

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.

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

2. Rows

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

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

c) Multiple rows can be hidden at a time.

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

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.

b) The column gets hidden.

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

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

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.

b) 2021 Actuals are hidden.

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

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.

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.

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