Reset

Reset option allows you to remove or revert any changes that have been made to a particular cell or range of cells, and restore them to their original state. Lumel EPM provides various reset options such as Reset formats, Reset value, Reset notes and Reset all.

• Reset formats: This option removes any formatting that has been applied to the cells, such as font color, font size, and cell borders.

• Reset value: This option resets any changes to the cell values.

• Reset notes: This option deletes all the notes added to the report.

• Reset header order: This option restores the ordering of header categories.

• Reset row order: This option reverts to the original ordering of row categories.

• Reset all: This option removes all the changes to the report including formatting, data edits, charts, filtering etc., and restores it to the original state.

In the 'Home' tab of the toolbar, select the 'Reset' icon from the 'Actions' section. You can see that, except for the Reset Formats and Reset Notes options, all other options are disabled. To enable them, you need to select one or more cells with formats applied or edited values.

Reset

1. Reset formats

In the below example, you can see some cells formatted with background and font color.

Select one or more cells with formatting applied. Click 'Reset formats' to remove the format.

Reset formats

The formatting has been reset.

Format style reset

Reset format is not applicable for conditional formatting, semantic formatting and the other formatting options available in 'Display settings'.

To reset formatting for the entire table, select the entire table (Ctrl + A) and reset all formatting.

Reset Formats by selecting the entire table

2. Reset value

In the below example, you can see that two values are edited in '2021 Actuals'.

Select the cells with edited values. Click 'Reset value' to restore the value.

Reset value

The cells have been restored to their original values.

Values are reset

3. Reset notes

In the below example, you can see that there are several notes added to the report. Click on 'Reset notes' to remove all the notes.

Reset Notes

In case you want to delete only selected notes and not all the notes, use the delete icon corresponding to the notes when you hover over them as shown in the image below

Deleting selected note

All the notes have been removed.

Notes removed

4. Reset Header order

Reset Header Order option helps to re-order columns. If you have re-ordered the fields for analysis, you can easily revert to the original sequence using the ‘Reset Header order’ option.

Here March column is re-ordered.

Reset header order option

The columns after Reset Header order.

5. Reset Row order

If you have re-ordered the rows in your reports, you can use this option to quickly restore the original order as configured in your data model. Note that sort cannot be used if the row order has been modified - you can apply this option if you need to revert to sorting.

Notice how the product names are re-arranged when the Reset Row order option is clicked.

Reset row order

In the next section, we'll start with adding business logic and formula.