MicroStrategy ONE
How to Display and Hide Grand Totals and Subtotals
A grand total is a total of all calculations on a report, for each metric. A subtotal is a total of a specific subset of metric data, totaled at a level you select. (For a definition and examples of levels of aggregation, see the Basic Reporting Help.) Common subtotal functions include sum, count, minimum, maximum, average, mean, and median. Grand totals and subtotals are often collectively referred to as totals.
A metric designer or report designer must enable totals as part of a metric's definition. If totals are available for a metric, you can display or hide them for that metric on a given report. You can add a new type of subtotal to the report. For example, if a report currently displays a Median subtotal, but you would prefer to see an Average subtotal, you can add the Average subtotal to the report. You can also permanently remove totals from the report.
You can add totals to a report on a document. For steps, see Analyze Documents.
To Display or Hide Existing Grand Totals and Subtotals on a Report
- Click the name of a report to execute it. The report must be in either Grid view or Grid and Graph view.
-
Click Toggle Totals
on the Data
toolbar.Alternatively, from the Data menu, select Show Totals. If this option does not appear, this means totals have not been enabled for at least one metric on the report.
To Display New Totals on aReport
- Click the name of a report to execute it. The report must be in either Grid view or Grid and Graph view.
- From the Data
menu, select Edit Totals
. -
Click the Definitions tab. You can add one or more subtotals to be calculated at all levels, or you can add grand totals only.
The list of subtotal functions is determined when the metric is created. If no functions are listed, subtotals have been disabled. For more information, contact the report's creator.
-
Click the Advanced tab and then, from the drop-down at the top of the dialog box, specify the subtotal for which to specify the way this subtotal should be calculated in the report: by position or across level.
For a definition of a level and examples, see the Basic Reporting Help.
The levels you can select from are:
-
By position: Under the Rows, Columns, or Pages (page-by fields) drop-downs, select the subtotal to apply to that part of the report. Each of these is considered an axis of the grid report. For each drop-down, select one of the following:
- All Subtotals: Apply the subtotal across all levels on the axis.
- Grand Total: Apply only the subtotal across the whole axis.
- None: Apply the subtotal to no level of the axis.
- Selected Subtotals: Apply only selected subtotals across the axis. This option is available only in the Pages drop-downs, for page-by fields.
- Across level: When you select this, all attributes available in the report are listed for you to choose from. Select those which you want to calculate the subtotal for.
-
- Once you have defined which subtotals should be calculated in the report, select the Display tab to define where these subtotals will be displayed in the grid.
-
For each axis in the grid, any subtotals calculated can be displayed in two ways: top of each level or bottom of each level.
-
Subtotal positions by row:
- Top of each level: Displays the row subtotal at the top of each level at which the metric is calculated.
- Bottom of each level: Displays the row subtotal at the bottom of each level at which the metric is calculated.
-
Subtotal positions by column:
- Left of each level: Displays the column subtotal at the left of each level at which the metric is calculated.
- Right of each level: Displays the column subtotal at the right of each level at which the metric is calculated.
-
Subtotal positions by page:
- Top of each level: Displays the page subtotal at the top of each level at which the metric is calculated.
- Bottom of each level: Displays the page subtotal at the bottom of each level at which the metric is calculated.
-
- Click OK.