MicroStrategy ONE
Calculating totals in documents
Totals reflect accumulations at selected levels and can be applied to any document. A metric is calculated differently depending on its location in the document; for specifics, see Calculating totals and summary metrics in documents.
A total uses the default subtotal function as set in the metric definition. To specify the function used to calculate a subtotal, create a summary metric.
To calculate a total
-
Open the document in the Document Editor. How?
-
In the Layout area, right-click the metric to be totaled and select Copy.
-
Right-click in the position to place the metric and select Paste.
-
If you copy the metric to a Group Header or Group Footer, the metric will be subtotaled at that level.
-
If you copy the metric to the Page Header, Page Footer, Document Header, or Document Footer, a grand total for the metric will be calculated.
-
Copying the metric from the Layout area also copies the metric's formatting. If you drag the metric from Dataset Objects, the control default formatting is used.