Basic interactions

We have used layouts, applied formatting, and added charts and visualizations in the previous section. In this section, we'll cover the following:

1. Explore & filter data - Lumel planning sheet provides features such as search, filter, KPI explorer, and Top N for data exploration and filtering. To learn more, refer to explore and filter data.

2. Sort & reorder data - Lumel EPM provides the standard sorting options - ascending/descending and A->Z/Z->A—and custom sorting using the drag-and-drop reorder feature. To learn more, refer to sort & reorder data.

3. Show/hide values - In the planning sheet, you can hide/unhide cells, rows, columns, or measures from the toolbar in a single click. To learn more, refer to show/hide values.

4. Manage column widths - Learn more about the ways to quickly adjust column width, especially when you have a lot of columns in the section manage column widths.

5. Manage hierarchies - There are several options such as expanding or collapsing row/column hierarchies to specified levels, descendants, and more. To learn more, refer to manage hierarchies.

6. Create visual hierarchies - Visual hierarchies in rows & columns can be created by selecting multiple items and grouping them. To learn more, refer to create visual hierarchies.

7. Pin rows & columns - You can pin rows/columns to the top or left of the report to easily keep track of important KPIs. To learn more, refer to pin rows & columns.

8. Actions - In this section, we'll cover some basic actions such as selections and formatting using rails, toolbar customizations, keyboard shortcuts, and reset.