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.

7. Displaying measures for specific time periods

You can use the Show/hide Measures interface to display the data for a particular period. You can create and save specific time ranges for measures and instantly access them like bookmarks.

You will need to enter a name to identify the measure time range, choose the measures to display, and select the time interval.

You can leverage the date picker to select the time range.

You can also display measures for relative time periods like last n days/weeks/months/years.

Another option is to use Inforiver's built-in date and time intelligence functions to display measures over a specific range of time. Select the Date Functions option in the Show/Hide measures interface. In the example below, we are displaying the Forecast measure based on the earliest and latest dates in the report.

After you create and save a measure time range, you can instantly switch between them and analyze your data.