Format Rule: Value

Value can be one of the highlight rules:

Let us have a look at it on an example of the pivot table:

Let us select the totals of those product categories for which the values of the “Sales Amount” measure are more than $ 1 million:

The following form appears:

This form contains the following parameters specific to Pivot:

• Format values that are greater than… – set value;
• Appearance/Icons – the “Appearance” tab allows you to choose the predefined background color/font, the “Icons” tab allows you to add the predefined icon;
• Intersection mode – the level at which the highlight will be The levels can be as follows:
  • Auto – identifies the default For the Pivot dashboard item, auto identifies the “First Level”;
  • First level – first level values are used to apply conditional formatting;
  • Last level – the last level values are used to apply conditional formatting;
  • All levels – all pivot data cells are used to apply conditional formatting;
  • Specific level – values from the specific level are used to apply conditional
• Row/Column dimension – if you specified the Intersection mode as “Specific Level”, use the “Row dimension” and “Column dimension” combo boxes to set the specific level;
• Apply to – to which element (measure, hierarchy) of the Pivot table the conditional formatting should be applied;
• Apply to row/column – apply to the entire row / to the entire

Fill out this form as follows:

As a result, the “Pivot” table will look the following:

To edit an existing highlight rule, click the “Options” icon next to the measure:

In the window that appears, double-click the rule or click an “Edit” button:

To delete the format rule, select the necessary format rule in the list in the “Edit Rules” window and click the “Delete” button:

If necessary, the rule can be temporarily disabled by unchecking the corresponding rule: