MicroStrategy ONE

About consolidations and subtotals

By default, subtotals for consolidations are disabled. This means that while you can subtotal a consolidation on a report, you cannot subtotal an object placed to the left of the consolidation on the report. That is, any subtotal which is defined across the consolidation and its higher levels is not shown on the report.

For example, a report contains Year, Month of Year, Category, and the Revenue metric, in that order from left to right. Notice that a consolidation is not included.

  • If you add grand totals, a total is calculated for the entire report. (Add grand totals by pressing F11.)

  • If you add subtotals, a monthly total, yearly total, and grand total are displayed. (Add subtotals by selecting Total on the Subtotals dialog box.)

  • If you subtotal across level, you can choose Year, Month of Year, and/or Category. (Subtotal across level by selecting Across level on the Advanced Subtotals Options dialog box.)

    For a more detailed description of subtotal across level, including an example, see Selecting a level for subtotal calculation and the Reports chapter of the Advanced Reporting Help.

In contrast, a similar report contains Year, a Season consolidation, Category, and the Revenue metric, in that order from left to right.

  • If you add grand totals to the report, no totals are displayed because the entire report is at a higher level than the consolidation.

  • If you add subtotals, the only total displayed is for Season. This occurs because Year and grand totals are at a higher level than the consolidation. That is, Year is to the left of Season on the report.

  • If you subtotal across level, you can only select Category. Year is displayed, but cannot be selected because it is to the left of Season, that is, Year is on a higher level than Season. Since subtotals are disabled for the consolidation, Season is not displayed.

Enable subtotals for the Season consolidation and then re-execute the report.

  • If you add grand totals, a total is calculated for the entire report.

  • If you add subtotals, a seasonal total, yearly total, and grand total are displayed.

  • If you subtotal across level, you can choose Year, Season, and/or Category.

For further details on these report samples, see the Custom Groups and Consolidations chapter of the Advanced Reporting Help.

Related Topics