Help Home

Using the Column Header Context Menu


When you mouse over the column headers in a report, if the report is offered to you in interactive mode, the Column Header Context Menu will pop up.

With the menu items, you can perform the following actions on the selected column (the column where the Column Header Context Menu is enabled):

Note

The color scheme you see may vary, but menu items provided and their functionality are the same.

Note

There is not an "undo" menu item through the context menu. Simply continue the use of the context menu until you reach your desired report layout.

Sort the Column

When you select Sort from the Column Header Context Menu, data in the report will be sorted based on the values in the selected column. The Sort function operates in a toggle mode. Therefore, if the column is already sorted, the sort order will be reverse. If the column has never been sorted, it will be sorted in the ascending order. To reverse the sort order, simply select Sort from the Column Header Context Menu again.

See Sorting Data for more details.

Hide the Column

When you select Hide from the Column Header Context Menu, the column will be hidden from view. To bring back a hidden column, move your cursor to one of the column headers, and as the Column Header Context Menu pops up, select Show All. This will show all columns available in the report and bring back all hidden columns. You cannot bring back only a most recently hidden member.

Note

You cannot hide the last column. When there is only one column left, selecting Hide from the menu will have no effect.

Show All Columns

When you select Show All from the Column Header Context Menu, all previously hidden columns will show up.

Rename the Column

When you select Rename from the Column Header Context Menu, the column header will become an editable text box. It may appear as <member/>, which will be substituted into the name of the member in that column. Enter the new name, and then either press Enter or click anywhere else in the report to apply the changes.

The column name can contain spaces, "_" ,"-", "&", and "#". See Renaming a Column for step by step instructions.

Note

When entering Japanese characters, the keyboard input needs to be set to either Hiragana, full-width Katakana, or full-width ascii.

Create a Break Group Based on Data Values in the Column

When you select Group from the Column Header Context Menu, the column becomes a break group. The report will be grouped based on the data values in the column. To clear this break group, see Adding or Removing a Break Group.

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. See Editing Text for Break Group Totals for details on how to remove, edit, or change aggregation type.

Clear all Break Groups in the Report

When you select Clear Groups from the Column Header Context Menu, all break groups will be cleared.

Style the Report

When you select Style... from the Column Header Context Menu, a Report Style dialog box pops up, allowing you to specify font size, style, color, and text alignment in your report. For details on report styling and the Report Style dialog box, see Specifying Font Face, Size, Style, Color, Text Alignment, and Background Colors.


Related Topics: