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:
- From the Data menu,
select Edit Totals (or select the
Edit Totals icon
in the Crosstab
toolbar).
- Select the check box next to the name of the desired "function" (such as
Total, Max, Min, Count, etc.) you wish to remove.
- 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.
|