Version 2021

Subtotals dialog box: Display Options tab

You can select the subtotal position display options, as described below.

Subtotal positions by row

  • Top of each level displays the subtotal at the top of each level at which the metric is calculated.

  • Bottom of each level displays the subtotal at the bottom of each level at which the metric is calculated.

The Subtotal positions by row section is grayed out and unavailable if metrics are sorted hierarchically. Hierarchical metric sorting takes precedence over subtotal display. To display subtotals at the top or bottom of the level when metrics are sorted hierarchically, specify the Total Position in the Sorting dialog box. For more detailed instructions, see Advanced sorting: hierarchical sorting.

Subtotal positions by column

  • Left of each level displays the subtotal at the left of each level at which the metric is calculated.

  • Right of each level displays the subtotal at the right of each level at which the metric is calculated.

Subtotal positions by page

  • Top of each level displays the subtotal at the top of each level at which the metric is calculated.

  • Bottom of each level displays the subtotal at the bottom of each level at which the metric is calculated.

Related Topic