MicroStrategy ONE

Enabling subtotals for custom groups

Steps to enable subtotals for a custom group

You can enable custom group subtotals at the report or custom group level.

  • The report level is governed by the Report Data Options, which allow you to disable or enable subtotals for each custom group on a particular report. For example, a report contains two custom groups. You can choose to subtotal on the Age Groups custom group but not on the Customer Deciling group. Alternatively, you can use the default setting, which is determined in the Custom Group Editor. For more information, seeReport Data Options dialog box: Subtotals.

  • The custom group level is governed by the setting in the Custom Group Editor, which allows you to enable or disable subtotals for a particular custom group, regardless of the report in which it is used. For instructions, see the procedure below.

Changing the position of totals

You can change the position of the totals for a custom group. This option is enabled only if subtotals have been enabled for the custom group. You can choose to display the totals at the top or bottom position, or inherit the default custom group definition. This option is set at the report level only. For more information on subtotal display, see Subtotals dialog box: Display Options tab. For more information and examples, see the Custom Groups and Consolidations chapter in the Advanced Reporting Help.

Prerequisite

This procedure assumes you have created a custom group. For instructions, see Creating custom groups.

To enable subtotals

  1. Open the custom group in the Custom Group Editor. (How?)

  2. From the Custom Group menu, select Options. The Options dialog box opens.

  3. Select Enable Subtotals Display.

  4. Click OK to return to the Custom Group Editor.

  5. Save the custom group. (How?)

Related Topic