Set Drilldown Summation Level

Use

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.

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

...

       1.      Choose  ® 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.

       3.      See Calculating and Deleting Subtotals.

       4.      Choose a relevant line.

       5.      Choose Apply.

Result

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.