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.
