Column Format in Analyses

When you build an analysis, you can edit properties for columns to control their appearance and layout. You can also specify formatting to apply only if the contents of the column meet certain conditions. By default, the specifications for a column apply only to the current analysis.

Because groups and calculated items are simply members of their respective columns, they inherit the formatting from the column and follow the same precedence order as for other members, unless you specifically apply formatting to the groups or calculated items.

What Kinds of Formatting Can I Apply?

You can use the tabs in the Column Properties dialog to customize how content is displayed for columns in views. Hierarchy levels provide an additional detail of formatting for hierarchical columns.

The following list provides examples of the kinds of formatting that you can apply:

• Apply cosmetic formatting to the column or hierarchy level, such as font family and size.

• Assign alternate folder and column heading names and apply custom formatting to them.

• Control the display of duplicate data, such as repeating column labels.

• Override the default formatting for columns and data values with custom formatting.

• Apply conditional formatting to the column or hierarchy level, which enables different formatting to be applied based on the values. For example, values greater than $1 million can be formatted with a green color.