Sorting and Collapsing Sections of Crosstabs

By default, the editor displays each row and column group of a Crosstab in a collapsed state. This means that you can see the totals for the group, but not the measures for its individual members. To see measures for a group's members, right-click the group label and select Expand Members.

When a group's members are expanded, select Collapse Members from the same menu to hide the measures. Collapsing an outer group also collapses its inner groups. The Expand Members and Collapse Members options are only available for outermost groups, or for inner groups nested in an expanded outer group.

When you collapse a group, its summary is automatically displayed; this prevents invalid Crosstab layouts, in which there is nothing to display for some totals if the summary has been deleted previously.