Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.
  • Madrid
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store

Create coloring rules for multilevel pivot table reports

Log in to subscribe to topics and get notified when content changes.

Create coloring rules for multilevel pivot table reports

Configure rules for how numerical values are displayed in a multilevel pivot table report, to easily highlight the more important values. The color rule is applied to the content of cells in pivot reports.

Before you begin

Role required: report_admin or admin


  1. On the Style tab of the Report Designer, 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.
  2. In the Multilevel Pivot Rules dialog box, click New rule.
  3. 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. This option applies only to multilevel pivot table reports.
    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.

  4. Click Submit to save the rule and create a new rule, or click OK to save the rule and return to the Report Designer.