Showing and Hiding Data Rows for Calculations

Use

You can show and hide data rows for intermediate results.

Hierarchical Structuring of Data Records

If you have defined multiple criteria to be used to generate intermediate results in the list, the intermediate results are structured hierarchically, depending on the sort sequence of the columns.

All data records with the same value in the first sorted column are merged into one block.
Within this block, the data records are then sorted according to the second column of the sort sequence.
And so on.

Note

Each intermediate result in the list is assigned a specific number of points. The number of points corresponds to the hierarchy level of the intermediate result. In other words: All intermediate results for a hierarchy level are assigned the same number of points.

Showing and Hiding Rows

You can show and hide data rows that contain the subvalues of an intermediate result. This ensures a concise and clear list.

You can show and hide rows for intermediate results in the following ways:

You choose a specific results row in the list and only show or hide the data rows for this particular intermediate result.
You collapse to the intermediate results. This allows you to show or hide all intermediate results for all data rows.

If you specified multiple criteria, you also hide the results rows from the lower hierarchy levels (see above). Only the results rows containing the intermediate results for the highest hierarchy level, as well as those with the overall results, remain visible.

Note

If the data rows of an intermediate result are visible, a small arrow icon that points upward is displayed next to the criterion in the corresponding results row.

If the data rows of an intermediate result are hidden, a small arrow icon that points to the right is displayed next to the criterion in the corresponding results row.

Procedure

Hiding Data Rows for Specific Intermediate Results

To hide the data rows for a specific intermediate result, choose the arrow icon in the results row.
To show the data rows again, choose the arrow icon in the results row.

Collapsing to Intermediate Results

To show or hide the data rows for all intermediate results, open the Settings dialog box (see Using the Dialog Box with Settings for the List).
Choose the Calculation tab.
Set the Collapse to Intermediate Results indicator.
Apply your settings to the list.