Show/hide values

The Planning Sheet 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/unhide multiple cells or cell ranges in a single click. Use Ctrl/Shift and click to select non-adjacent or adjacent cells, then click on the hide/unhide icon.

Hiding multiple cells

2. Rows

a) To hide a row or multiple rows, select the rows using Shift/Ctrl + and click on the hide icon.

Hiding a row

b) To unhide, click on the 'Show/hide' dropdown -> 'Rows' -> 'Unhide'. You can choose to unhide selected rows or all rows as required.

Unhiding a row

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/columns and click on the 'Hide' icon.

Hiding a column

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

Hiding a column from the column gripper

c) To unhide, click on the 'Show/hide' dropdown -> 'Columns' -> 'Unhide'. You can choose to unhide selected columns or all columns as required.

Unhiding column

4. Measures

You can also hide/unhide measure or row hierarchies by unchecking/checking the check box under the Manage Columns option. By default, all the Rows and Measures are checked and visible.

Manage Columns

To hide a measure/row uncheck the corresponding checkbox. In the image below the Variant rows and the Revenue columns are hidden.

Hiding rows/columns using the manage column option

You can unhide them by checking the corresponding boxes under the manage columns.

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

The image below shows the Quarter Name hidden, which can be unhidden by clicking on the Unhide icon.

Quarter-Name is hidden

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.

You can skip/hide rows from the action options in the row gripper, as shown in the image below.

Skip/Hide rows using row gripper

The hidden/skipped rows can be shown using the unhide option.

Unhiding Skipped rows

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.

Disable the Show toggle to hide measures for a specific time frame.

Show/Hide measures for specific time range

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

Date picker

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

Defining relative time frames

Another option is to use Lumel EPM'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 Units Sold measure based on the end of the week and end of the month in the report.

Using date functions to show/hide measures

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

Switching between time ranges