Formatting Column Group Labels in a Report


When you add a field to the Column Groups bucket in a report, measure columns are repeated for each value in that field. The column group, or across column, field values are shown above the column titles for each measure field, identifying the dimension values by which they are aggregated.

When creating a report with column group fields, such as a crosstab report, you can select Column Groups from the quick access menu on the Format tab to style the field names and values for each one. As when styling columns in a report, from the Select Elements and Columns menus, you can choose whether to style the field titles and values, or just one or the other. You can also choose whether to style the field titles and values for all column group fields, or a single column group field. Note that while the default field selection is All Columns, column group field names and values display in a row. All Columns in this case refers to all columns from your data source, and allows you to style column group field titles and values for all fields in the Column Groups bucket.

You can style column group field titles and values by changing the font, style, alignment, size, and color of the text; changing the background color of the title and values; and adjusting margins.