Skip Navigation
Online help
Totals

Totals and subtotals
Add totals to a report
Remove a specific total from a report
Show/Hide all totals
Remove all totals from a report

Totals and subtotals
A report can have totals and subtotals defined for it and saved as part of the report definition. Through MicroStrategy Web, you can add additional totals to the report, toggle totals on or off (once they have been added), and remove them permanently. These are explained below.

Add totals to a report
To add totals to a report, from the Data menu, select Edit Totals. Select the check boxes that correspond to the totals you want to display. Totals can also be added or removed from a report using Desktop, and even more options are available in Desktop, such as defining more precisely which levels the totals displays for and whether they appear for rows/columns/both/or neither.

Note: You may not have privileges to change this setting. For more information, contact your administrator.

Remove a specific total from a report
You may wish to remove one of several totals from a report. For example, if there are Total, Min, Max, and Average totals you may wish to remove only the Min total. To do this:
  1. From the Data menu, select Edit Totals (or select the Edit Totals icon in the Crosstab toolbar).
  2. Select the check box next to the name of the desired "function" (such as Total, Max, Min, Count, etc.) you wish to remove.
  3. Click Apply to view the report with these new selections.
    -OR-
    Click OK to view the report with these sorting selections and close the panel or dialog box. 

Show/Hide all totals
If a report already has totals defined, you can choose to toggle all of them to be visible or hidden. If you hide the totals and then show them again, you will get back all of the totals that were defined for the report exactly as before you hid them. You will not need to redefine them.

To toggle the display of totals:

From the Data menu, select Show Totals. Check the totals you want to appear in the report.

  • If DHTML is disabled: From the Data drop-down list, select Show Totals, then click the Go icon next to the drop-down list. Check the totals you want to appear in the report. 
If a report has no totals defined (either because the report is new, or someone chose to Clear All totals from the report), you cannot turn them on and off. The Show Totals option is disabled until you add a total to the report.

Remove all totals from a report
To remove all totals defined for a report, from the Edit Totals panel or dialog box, clear the totals you no longer want to see on the report. This actually removes totals from the definition of the report; it does not hide them. If you clear all totals and want to bring them back you must add them back one by one.