You can use the Suppress Column Grand Totals dialog box to specify whether to show the grand total column for a common crosstab, or to customize the visibility of the grand totals of the column compound groups for a compound crosstab. This topic describes the options in the dialog box.
Designer displays the Suppress Column Grand Totals dialog box when you select the ellipsis next to Suppress Column Grand Totals in the Layout screen of the Create Crosstab dialog box or Crosstab Wizard dialog box.
You see the following options in the dialog box:
Same for all
It is meaningful to use this option for a compound crosstab. Select it to apply the setting for the grand total of the first column compound group in the box below to all the grand totals of the column compound groups in the crosstab.
This column shows all the column compound groups in the crosstab. A common crosstab has only one column compound group.
This column shows whether you specify to suppress the grand totals of the column compound groups. To specify the value, select in the value cell and select "true" or "false" from the drop-down list.
Select to apply your settings and close the dialog box.
Select to close the dialog box without saving any changes.
Select to view information about the dialog box.