Help Home

Adding or Removing a Break Group


This section describes how to:

Adding a Break Group

To add a break group to your report:

  1. Move your cursor to the header of the column you want to make into a break group. The Column Header Context Menu pops up.
  2. Select Group from the menu.
  3. The report is now grouped based on the data values in the column.

Once you add a break group, aggregation data (sum, average, minimum, maximum, or count) will appear at the end of each break group for each numeric column. When you mouse over the aggregation data, the Group Total Context Menu pops up, allowing you to change aggregation type and edit the text. For details on the Group Total Context Menu, see Using the Group Total Context Menu. For details on editing footer text, see Editing Text for Break Group Totals.

Removing a Break Group

To remove a break group:

  1. Move your cursor to one of the break group headers. The Group Header Context Menu pops up.
  2. Select Clear Group from the menu. The current level of break group from which you activate the Group Header Context Menu is now cleared.

Removing All Break Groups

To remove all break groups:

  1. Point your cursor at any column headers. The Column Header Context Menu pops up.
  2. Select Clear Groups. All break groups are now cleared.

Sorting the Break Group Headers

If you want the break group headers to be listed in an ascending or descending order, before you make a column a break group, you should first sort it through the Column Header Context Menu. For example, you may want the report to be grouped by "Product" and the products to be listed in alphabetical order. To do so, sort on "Product" through the Column Header Context Menu first. Then make "Product" a break group. See Sorting Data and Adding a Break Group.


Related Topics: