Modifying Table Grouping Properties
To customize sort order, ranking, and granularity for a given group, follow the steps below:
1. Click the 'Edit Dimension' button in the Binding panel for the desired group.

2. From the top menu, select the desired sort order for the group.

The 'By Value(Asc)' and 'By Value(Desc)' options are only available when a measure is specified in 'Summary' panel.
The 'Ascending' option orders the groups alphabetically, while 'Descending' orders the groups reverse-alphabetically. The 'By Value(Asc)' and 'By Value(Desc)' options rank the groups according to the summarized measure specified by the 'Column' menu.
3. For a date-time field, use the 'Level' field to specify the granularity of the date binning: day, month, year, etc.

4. To specify a coarser grouping granularity by defining more inclusive grouping categories, select the 'Customize' option in the 'Named Groups' menu, and click the 'Edit' button. See Named Groups for information on how to specify the groups.
5. To use a named group that you previously created in a Data Worksheet, select the desired group from the 'Named Groups' menu. See Creating a Named Grouping in Data Mashup for information on creating such groupings.
6. To filter and rank a specified number from among the top or bottom groups (according to a given summarized measure) follow these steps:
a. Select 'Top' or 'Bottom' from the 'Ranking' menu.
b. Choose the desired number of groups, and specify the aggregated measure that should be used to determine the ranking.
When you specify multiple grouping fields, 'Group all others together' is available only for the lowest grouping level.
c. Select 'Group all others together' to include as a separate category groups that are not amongst the specified top or bottom groups. Otherwise, these groups do not appear in the Table or Section.

4. Select 'Page Break After Group' to force a page break after the final record in the selected group (or after the summary, if one is displayed).
5. Click the 'Apply' button (green arrow) to submit the changes.
| << Grouping Data in a Table | © 1996-2013 InetSoft Technology Corporation (v11.4) | Setting Global Grouping Options >> |