Show or Hide Subtotals
You can use screen space most efficiently by specifying
which subtotals to show and which subtotals to hide.
You can specify the default subtotals to show for all existing and new sets in the analysis. You can also override these default settings for individual sets.
You can also show and hide subtotals using the properties pane.
The only subtotal you can use with selection-based sets is Total.
Procedure
- Choose whether to specify the default subtotals to show
for all existing and new sets in the analysis or for an individual
set:
- To specify the default subtotals to show
for all existing and new sets, from the Settings menu,
click Totals and Subtotals.Tip: To view the values for the More & hidden subtotal, change Don’t show values to Show the values.
- To specify the default subtotals to show for an individual set,
select the set, and then click the subtotals button
on the toolbar.
- To specify the default subtotals to show
for all existing and new sets, from the Settings menu,
click Totals and Subtotals.