Close
Thank you for your feedback.

Create a coloring rule for a multilevel pivot table

Create a coloring rule for a multilevel pivot table

Create coloring rules to change the color of a table cell of a multilevel pivot table based on its value.

Before you begin

Role required: report_admin or admin

Procedure

  1. Navigate to Reports > View / Run.

  2. Click a report with a Type value of Multilevel Pivot to open it.

  3. Click the Style your chart icon (Cogwheel).

  4. Click Edit coloring rules.

  5. Click New rule.

  6. Fill in the fields on the form.

    Table 1. Multilevel pivot rule fields
    FieldDescription
    OperatorThe operator used when evaluating values in cells, such as greater than or between. For example, to style cells with a value less than 5, select lower than and specify a Value 1 value of 5.
    Value 1The number to evaluate cell values against. When the Operator value is between, enter the lower value in the Value 1 field.
    Note: When creating rules based on a duration value, specify the duration in seconds.
    Value 2The maximum value a cell can contain to match this rule. This field only appears when the Operator value is between.
    Font colorThe font color to apply to cells that match this rule.
    Background colorThe background color to apply to cells that match this rule.
    Rule orderA numerical value that determines the order in which rules apply. Rules with a higher rule order apply later and override lower-order rules.

    For example, one rule matches cells with a value greater than 140, and another rule matches cells with a value less than 150. The rule with the higher order applies to cells with values from 141 through 149.

  7. Click Submit.

  8. Click Close.

  9. Click Run to generate the report using the rules.

Products > Performance Analytics and Reporting > Reporting; Versions > Istanbul