MicroStrategy ONE

Setting subtotal display for custom groups

For each custom group on a report, you can select to allow or disable subtotaling. For example, you can subtotal on the Age Groups custom group but not on the Customer

To enable subtotal display for custom groups

The following procedure sets the subtotal option at the report level. To set it at the custom group level, see Enabling subtotals for a custom group.

Prerequisite

The Subtotals dialog box is operational only when there is a custom group on the report. Ensure there is at least one custom group on the report before completing step 2 of this procedure.

To set subtotal display

  1. Open the Report Editor. (How?)

  2. From the Data menu, choose Report Data Options. The Report Data Options dialog box opens.

  3. Under Categories, expand Calculations, and then select Subtotals. Calculations - Subtotals appears on the right side of the editor.

  4. Click in the cell under Allow Subtotals to change the display of subtotals. You can select from Default, Yes, or No.

    When default is used, the object inherits the property set in the Custom Group Editor. That setting in the editor is inherited, by default, for any report that uses that custom group.

  5. Click OK to close the Report Data Options dialog box.

  6. Save your report.

Related Topics