MicroStrategy ONE

Metric Editor Subtotals/Aggregation tab: Layout

The Subtotals/Aggregation tab contains the following:

  • Total subtotal function: From the drop-down list of functions, select the default function to calculate report subtotals.

    This allows you to use different grand total functions for different metrics on the same report, for instance.

  • Dynamic aggregation function: From the drop-down list of functions, select the function to calculate dynamic aggregation.

  • Available subtotals section: Select the functions to be available for subtotal calculation by selecting them from Project subtotals and clicking the > button to move them to Available subtotals for metric. When you select a function in either list, its description and syntax appear at the bottom of the dialog box.

    In a report containing this metric, you can choose which of the available subtotal functions to apply as a report subtotal.

  • Allow Smart Metric: Select whether to apply smart metric functionality. Smart metrics calculate subtotals on individual elements of the compound metric.

    The smart metric option applies to compound metrics and certain other metric types only; the check box is not accessible for all metric types.

Your choices for both the Total subtotal function and Available subtotals are standard predefined subtotal functions, which are simple aggregate functions such as Total and Count that satisfy many subtotaling requirements. If they do not answer your specific needs, you can create a user-defined subtotal and use it just like any of the built-in subtotal functions. For a list of the predefined subtotal functions, see Metric Editor Subtotals/Aggregation tab: Functions. For more information on user-defined subtotals, seeAbout user-defined subtotals.

Disabling subtotals

You can also choose to disable totaling on a metric such as an inventory metric or another non-aggregatable metric. To do this, set the Total subtotal function to None and clear the Available subtotals list.

If you set the total subtotal function to None but do not clear the available subtotals, grand totals are unavailable in reports except by applying subtotals. If you clear the Available subtotals for metrics list and set a total subtotal function, only that function is available for subtotal calculation.

Related Topics