Removing 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 on 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.

Prerequisites

The steps below assume there are totals enabled for at least one metric on the report.

Warning

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:

Example of Subtotals Editor

To remove totals from a report

  1. Click the name of a report to execute it. The report must be in either Grid view or Grid and Graph view.

  2. From the Data menu, select Edit Totals. The Subtotals Editor is displayed.

  3. Click the Definitions tab.

  4. Clear the check boxes for the totals you no longer want to see on the report. The selected totals are permanently removed from the report.

  5. Click OK to confirm your changes and return to the report.

Related topics