Total mode

View the total value for the selected period.

Use Total mode to view the total value for the selected period.

Unlike Period mode, Total mode displays only the total value and does not include cumulative values. Total mode is the simplest view of your data. It is particularly useful when multiple measures are selected because it provides a clear, uncluttered summary of your data.

Use the Measures menu to add more measure columns to the grid.

Summary view

Displays the total value for each period within the selected date range.

The grid contains the following columns:

• Period: Displays each period within the selected date range. For example, when you select Rolling 12 Months, the grid displays a row for each month in the rolling 12-month period.
• Value: Displays the total value for each period.

Summary view of Total mode

Dimension view

Displays the total value for each entity in the selected dimension.

In this view, the Properties menu in the toolbar becomes available.

The grid contains the following columns:

• Properties: Displays the selected properties (such as Code and Name) for each entity. Use the Properties menu to select which properties to display. The available properties depend on the selected dimension.
• Value: Displays the total value for each entity across the selected period.

Dimension view of Total mode

Example

Use Total mode to view the total number of products sold this year to date (YTD):

1. Click Mode > Total.
2. Click the Product dimension.
3. Click Measures > Quantity and clear any other selected measures.
4. Click Period > FYTD.

Quantity of each product sold in the financial year to date