MicroStrategy ONE
How to Remove Totals
It is not always necessary or desirable to have grand totals and subtotals displayed in a report. Removing totals is different than hiding them. When you remove totals from a report, you actually remove them from the report definition. This means that when the report is re-executed, totals will no longer be enabled for the report. You can remove certain totals and let others remain on the report, or you can remove all totals from the report.
The steps below assume there are totals enabled for at least one metric on the report.
Do not clear (sub)totals without keeping a record of the totals added originally. Removing them requires adding each one back individually by checking the boxes shown below in the Subtotals Editor:
To Remove Totals from a Report
- Click the name of a report to execute it. The report must be in either Grid view or Grid and Graph view.
- From the Data menu, select Edit Totals.
- Click the Definitions tab.
- Clear the checkboxes for the totals you no longer want to see on the report. The selected totals are permanently removed from the report.
- Click OK to confirm your changes and return to the report.