4.3.5  Grouping Crosstab Headers into Named Groups

You can agglomerate data from different crosstab header values into larger categories called named groups. For example, you can combine column header labels designating individual states MA, CT, NY, NJ, etc., into larger groups such as 'New England' and 'Mid-Atlantic'.

Named groups cannot be defined for date fields.

To create named groups for crosstab header labels, follow the steps below:

1. Ctrl-click to select the individual crosstab header labels (from the same heading level) that you want to combine into a single group.

You can group exist­ing groups to make larger groups.

2. Right-click on one of the selected labels, and select 'Group' from the context menu. This opens the 'Group Name' dialog box.

 

3. Enter a name for the new group in the 'Group Name' dialog box, and click 'OK'.

 

This replaces the selected labels with the label for the named grouping, and agglomerates the data corresponding to the original labels under the new label.

 

4. Repeat the above steps to add additional named groups.

To decompose an existing name group, right-click on the header label and select 'Ungroup' from the context menu.

 

See Also

Grouping Chart Labels into Named Groups, to create groupings in a chart.

<< 4.3.4 Percentage Representation for Aggregation © 1996-2013 InetSoft Technology Corporation (v11.5) 4.3.6 Drilling Down into a Crosstab >>