MicroStrategy ONE

Subtotal Expressions

Subtotals allow you to dynamically control the computation and display of report data within desired groupings. Subtotals are applied to report metrics to calculate totals and for dynamic aggregation.

The standard predefined subtotal functions, which are automatically available for use with every metric and report, are simple aggregate functions that satisfy many subtotaling requirements. If they do not answer your particular needs, you can create a user-defined subtotalusing the Subtotal Editor or through the SDK. User-defined subtotals allow you to develop your own subtotals, using single-value functions or group-value functions.

Both predefined and user-defined subtotals can be applied to reports from the Subtotals/Aggregation tab in the Metric Editor.

For more information on subtotals and the procedures for creating and applying them, see the Reports chapter of the Advanced Reporting Help or the MicroStrategy online help.

Example: Division ( / )

Sum(Sum(x*[Units Sold]){Year}/Sum([Units Sold]){Year}){}

To Access Functions in the Subtotal Editor

  1. Log in to a project.
  2. In the MicroStrategy Developer File menu, point to New and then select Subtotal. The Subtotal Editor displays.
  3. The Subtotal Editor is very similar to the Metric Editor. To access the functions used to create a new subtotal, you can do one of the following:
    • Expand the Functions and Operators folder using the drop-down list or shortcut list in the Object Browser pane. Then expand the Functions, Operators or Plug-In Packages folder to access the various categories of functions and operators.
    • Click (Insert Function) in the Definition pane. The Insert Function wizard opens.
    • Enter the function name and all required subtotal syntax directly in the Enter your formula here box.