MicroStrategy ONE

Making subtotals available to a metric

This procedure allows you to select the functions to be available for subtotal calculations for the selected metric. For more information on subtotals for metrics, see About metric subtotals.

To make subtotals available to a metric

  1. Open the metric in the Metric Editor. (How?)

  2. Click the Subtotals/Aggregation tab.

  3. Select the function or functions in the Available project subtotals list.

  4. Click the > button to move the selections to the Available subtotals for metrics list. Or, you can move all the project functions to the metric functions list by clicking >>.

    If the Available subtotals for metrics list is blank, only the Total subtotal function is available for subtotal calculation.

  5. To view a function's definition and syntax, select it in either list.

  6. Click Save and Close to save the metric and close the Metric Editor.

To display subtotals on a report, see Applying subtotals to a report.