The Pivot dashboard item supports the conditional formatting feature that provides the capability to apply formatting to cells whose values meet the specified condition. This feature allows you to highlight specific cells or entire rows/columns using a predefined set of rules. To learn more about conditional formatting concepts common for all dashboard items, see the Conditional Formatting topic.
The Pivot dashboard item allows you to use conditional formatting to measures placed in the Values section and dimensions placed in the Columns/Rows sections.
Note that you can use hidden measures to specify a condition used to apply formatting to visible values.
New appearance settings are applied to pivot data cell or cells corresponding to column/row field values.
To create a new format rule for the Pivot's dimension/measure, do one of the following.
Depending on the selected format condition, the dialog used to create a format rule for Pivot contains different settings. For instance, the image below displays the Greater Than dialog invoked for the measure.
This dialog contains the following settings specific to Pivot.
Intersection mode specifies the level on which to apply conditional formatting to pivot cells. The following levels are supported.
Take note of the following behaviors specifics:
To edit format rules for the current Grid dashboard item, use the following options.
Both these actions invoke the Edit Rules dialog containing existing format rules. To learn more, see Conditional Formatting.
The Pivot dashboard item allows you to apply conditional formatting to data cells or field value cells. The PivotDashboardItem.FormatRules property provides access to a collection of PivotItemFormatRule objects that are used to define formatting settings.
To add a new format rule, create the PivotItemFormatRule object and specify the following settings.