Add Group Breaks

The number of group break levels that you can create depends on how many categories or hierarchies are in the report section. For example, if you have three categories and two hierarchies, then you can specify four breaks, which means that you will see one drop-down list for Break by values of and three drop-down lists for Then by values of.

Note: Group breaks cannot be used on different levels of the same hierarchy.

Data items that act as hyperlinks are not allowed to be group break variables, so they are always removed from the list.

To specify group breaks, complete these steps:

In Edit mode, select DataGroup Breaks or from the Table of Contents panel, select OptionsGroup Breaks to open the Group Breaks dialog box.
On the Group Breaks tab, complete these steps:
1. Select the first group break level in the Break by values of list. The Break by values of list contains all the categories and hierarchy levels in the report section.
  
  Note: If you select a data item that is already assigned to a table or graph, it will be removed from that object.
2. (Optional) Select additional group break levels from any available Then by values of list.
3. Select a sort option for the category or hierarchy level values. The default is Ascending.
  
  Note: If the data cannot be sorted, this option is not available.
4. (Optional) Select the New page for each value check box.
5. (Optional) Use the formatting tools to change the default font, font size, font style, background color, and foreground color.
6. (Optional) Select the Label each value option to label each group break with its category or hierarchy name. If you include a dynamic measure with one or more group breaks, then this option also applies to labeling measures.
  
  For multidimensional data, select the Label each value option to label each group break with the hierarchy and level names, followed by the value (for example, PRODHIER.PRODNAME: Furniture.Bed).
  
  Group Breaks Tab in the Group Breaks Dialog Box
(Optional) Use the Measure values tab to complete these steps:
1. Select a group break in the For group break level drop-down list. The list contains the group breaks that you selected on the Group Breaks tab.
2. In the Show measure value list, select the measure value that you want to display for each group break level. For example, if you select Country as the group break level, you might select Total Profit as the data item value. The profit aggregated across each country is displayed at each group break level.
  
  Note: The measure value is an aggregation for each group break that you selected.
  
  Measure Values Tab in the Group Breaks Dialog Box
  
  Note: If you remove the selected measure from the report, then the measure value is removed from the group break.
3. Click Add to add your For group break level and Show measure value selections to the Group break level/value box.
Click OK.
For reports that contain tables, graphs, or geographical maps that have been filtered, drilled, or expanded, these actions are taken:
- Filters and conditional highlighting that depend on a data item that you have selected as a group break are removed from the filtered table, graph, or geographical map.
- Navigation (drilling or expanding) that has been performed on a data item that you have selected as a group break are removed from the drilled or expanded table, graph, or geographical map. (Expanding and drilling are performed in View mode.)
In addition, if you create a group break that is based on any level in a geographic hierarchy, then any geographical map in the report section becomes invalid.

Note: To collapse the Group Breaks section, click

Here is an example of how group breaks appear in a report that is based on multidimensional data:

Group Breaks for Multidimensional Data