A grand total is a total of all calculations on a report, per 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 MicroStrategy Basic Reporting Guide.) 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.
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. Subtotals are displayed at all levels of the report.
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; see Prerequisites, above.
If DHTML is disabled, click the Go icon.
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 
. The Subtotals dialog
box is displayed.
If DHTML is disabled, click the Go icon.
Click the Definitions
tab. You can add one or more subtotals to be calculated at all levels,
or you can add grand totals only.
Note: 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 list 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.
Note: For a definition of a level and examples, see the
MicroStrategy Basic Reporting
Guide.
The levels you can select from are:
By position: Under the Rows, Columns, or Pages (page-by fields) drop-down lists, 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 list, 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-down lists, 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 to complete the subtotal definition. The subtotals are displayed on the report.
Related topics