Formatting a crosstab

Measure labels are displayed in the crosstab based on their status as a row or column.

You can pivot an entire crosstab or you can pivot rows and columns to change vertical and horizontal orientation.

1. To pivot an entire crosstab, click .
   The row and column groups switch places
2. To pivot a single row group, right-click it and select Switch To Column Group.
3. To pivot a single column group, right-click it and select Switch To Row Group.

You can keep or exclude group members in a crosstab.

1. To remove all groups except the selected group, right-click a group member and select Keep Only.
2. To remove a group, right-click a group member and select Exclude.

All row and column groups are summarized automatically. You can turn off group summary.

1. To turn off a group summary, right-click any heading in the group and select Delete Row Summary or Delete Column Summary.
2. To reapply a summary, right-click the heading and select Add Row Summary or Add Column Summary.
3. To select the summary function and data format for a measure, right-click the measure label and select a function.
   • Sum.
   • Average.
   • Maximum.
   • Minimum.
   • Distinct Count. The number of different items in a row or column.
   • Count All. The total number of items.

By default, each row and column group of a crosstab is displayed in a collapsed state. You can see the totals for the group, but not the measures for its individual members.

1. To see measures for group members, right-click the group label and select Expand Members.
2. To collapse group members, right-click the group label and select Collapse Members.

By default, cells that contain the same data are merged into a larger, single cell to make the crosstab data easier to read.

1. To display all of the individual cells in the crosstab instead of merged cells, place the cursor over and select Unmerge crosstab cells.
2. To merge cells, place the cursor over and select Merge crosstab cells.

You can sort a crosstab into ascending or descending order.

You can filter the numeric data that is shown in a crosstab.

1. Right-click the heading that you want to use for filtering and select a filtering option.
   • Filter Top N Values
   • Filter Bottom N Values
   • Don't Filter Values
2. Enter the number of values you want to show in the crosstab.
3. Select whether to show an aggregate of the unranked values in the crosstab.
4. Select whether to apply the filter across all row groups.
5. Click OK.
   The crosstab is updated to reflect your filter option. The icon appears in the heading when a column is filtered for the top N values. The icon appears when a column is filtered for the bottom N values. A blue dot appears in the menu next to the currently applied filter option.