MicroStrategy ONE
Subtotals Editor: Advanced Tab
If you arrived here from Workstation, see the Workstation Document Authoring Help.
Use the Advanced tab of the Subtotals Editor to specify whether each metric subtotal is calculated by position on the report rows, columns, and page-by fields, or across specific levels on the report. You can also specify the level at which you want the subtotal to be calculated.
From the drop-down list at the top of the dialog box, specify the subtotal to be calculated by position or across level:
- 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:
- Rows and Columns:
- 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.
- Pages:
- Selected Subtotals: Apply only selected subtotals across the axis.
- Grand Total: Apply only the subtotal across the whole axis.
- None: Apply the subtotal to no level of the axis.
- All Subtotals: Apply the subtotal across all levels on the axis.
- Rows and Columns:
- Across level:
- Select Levels: Apply the subtotal to all attributes available on the report. When you select this, all attributes available in the report are listed for you to choose from. Select those for which you want to calculate the subtotal.
Related Topics
How to Display and Hide Grand Totals and Subtotals