Formatting and conditional formatting

Each Pivot can be formatted using the Format menu, Format toolbar, or formatting options contained in the right-click menu. Font colors, font styles, borders, backgrounds, number formats, and text justification can be set and configured to produce the desired formatting of the Pivot. To format item(s) in the Pivot, highlight and right-click on the item(s) of interest and use the desired formatting options.

Conditional formatting

Conditional formatting is used to apply formatting to a particular data column based on a condition. The conditional formatting feature is a new feature to Interactive Reporting and replaces the previous Spotlighter functionality. Conditional formatting is commonly used to draw attention to numerical values in the Fact columns of Pivots but the feature can also be used on Row or Column labels. To apply conditional formatting to a Pivot, select the Conditional Formatting menu item from the Format menu. The Conditional Formatting...