Show TOC

Procedure documentationSetting the Drilldown Summation Level Locate this document in the navigation structure

 

If you have defined subtotals for your list, you can hide entries and subtotals as a group for a summation or subtotal level. See Calculating and Deleting Subtotals.

Procedure

The starting point is a list with multiple subtotals.

This graphic is explained in the accompanying text.

To hide all entries and subtotals for a summation or subtotal level, proceed as follows:

  1. Choose Drilldown Summation Level (Drilldown Summation Level).

  2. In the Set Drilldown Summation Level dialog box, select the subtotal level to remain displayed in the list. The number of asterisks corresponds to the number of small squares in the list. See Calculating and Deleting Subtotals.

  3. Choose a relevant line.

  4. Choose Apply.

Result

This graphic is explained in the accompanying text.

The totals and subtotal levels are displayed according to the selection you made in the Set Drilldown Summation Level dialog box. The icon indicates that entries under this subtotal are hidden. Since another level is displayed under the second subtotal level, the subtotals on the second level and the totals line are displayed using the icon.