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.
    If you see the error message 'Security constraints prevent access to requested page,' an ACL is preventing access. If necessary, a user with the security_admin role should create new read and write ACLs on the Multilevel Pivot Rule [sys_report_mpivot_rule] table.
  5. Click New rule.
  6. Fill in the fields on the form.
    Table 1. Multilevel pivot rule fields
    Field Description
    Operator The 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 1 The 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 2 The maximum value a cell can contain to match this rule. This field only appears when the Operator value is between.
    Font color The font color to apply to cells that match this rule.
    Background color The background color to apply to cells that match this rule.
    Rule order A 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.