Top & Bottom Analysis report layout

This section describes the structure of the Top & Bottom Analysis report layout and its key components.

The Filter panel and data grid in the Top & Bottom Analysis report work together dynamically to help explore data across multiple dimensions. When you interact with the report and use functions such as Analyze By and Expand To, dimensions move between the filter and data grid depending on your actions.

Note: A dimension can only be displayed in one place at a time, either in the Filter panel or in the data grid, but not in both. For more details, see Top & Bottom Analysis report key features.

This table shows the elements of the Top & Bottom Analysis report layout.

Name Description
Control tab Navigates to other reports.
Application Context panel Shared across all C-Suite reports.
Filter panel Shared across a C-Suite reports.
Data grid Shows the values of the dimensions and differences between the values.

Δ is the difference between the reporting and comparison periods.

Δ% is the percentage difference between the reporting and comparison periods.

Shows up to three dimensions side by side. Each dimension is displayed in a separate column.

The broken hierarchy layout enhances flexible, multidimensional analysis.

Shows 25 records by default. You can choose how many top or bottom records to show by selecting a number from the Elements list in the Top/Bottom menu. The rest of the records are grouped under the Others category.

The Others row is not available for ratio or percentage metric types.

Standard toolbar

Includes functions that are independent from any selections in the data grid such as Top/Bottom, Expand To, Rows, Columns, Data setting, and Export.

The standard toolbar is always displayed.

Contextual toolbar Accessible only when a cell or column in the data grid is selected. The menu contains these functions: Analyze by, Zoom In, Zoom Out and Remove Column.

The title of the toolbar reflects one of these selections:

  • Cell selection: 1 element selected
  • Column selection: 1 column selected

If you close the contextual toolbar with the X icon, all selections are cleared.

Contextual menu Accessible with a right-click only when a cell or column is selected in the data grid. The menu contains these functions: Analyze by, Zoom In, Zoom Out, Reset Zoom and Remove Column.