In the Ad Hoc Editor, the icon lets you change how the groups are displayed. Depending on the type of report you are
viewing, the behavior varies:
- Crosstabs: Moves the row groups to column groups and vice versa. This action is also referred to as pivoting. This option is only available for crosstabs that have both a column group and a row group.
- Charts: Displays the alternate group. This option is only available for charts that have a column group. When multiple row or column groups are defined, the Chart tab displays the outermost group.
- Tables: Displays the alternate group. This option is only available for tables that have a column group. When multiple row or column groups are defined, the Table tab displays the first group in the set (the outermost group).
By default, a table or chart is grouped by the column group; click to group it by the row group.
Note: For this feature to be available for tables and charts, the report must be edited as a Crosstab to add a column group. Otherwise, there is no alternate group to switch to. When you design a table or chart and then view the Crosstab tab, you only have a row group defined. Drag a field into the column group to complete the crosstab.