KB13075: When trying to add a subtotal to a report with a consolidation, the message ‘There is at least one consolidation defined in this report for which subtotals are not allowed’ appears in MicroStrategy Developer

• Strategy

When trying to add a subtotal to a report with a consolidation, the message ‘There is at least one consolidation defined in this report for which subtotals are not allowed’ appears in MicroStrategy Developer.

A user has created a report with a consolidation in Strategy Desktop 9.x. When trying to add a subtotal to the report, the following message appears:


There is at least one consolidation defined in this report for which subtotals are not allowed. Any subtotal which is defined across the consolidation and its higher levels will not be shown.

CAUSE:
The subtotal option is disabled in the Consolidation Editor.
ACTION:
To enable adding subtotals to the report, the subtotals option needs to be enabled in the Consolidation by choosing Elements -> Subtotals -> Enabled in the Consolidation Editor, as shown below:

13075 KB13075

Comment

0 comments

Details

Knowledge Article

Published:

May 17, 2017

Last Updated:

December 31, 2018