Configure rules for how numerical values are displayed in a multilevel pivot table report. Coloring rules make it easy to 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
Note: It isn’t possible to apply coloring rules to the Total cells in multilevel pivot reports.

Procedure

  1. On the Style tab of the Report Designer, select Edit coloring rules.
    If you see the error message 'Security constraints prevent access to requested page,' an access control list is preventing access. If necessary, one with the security_admin role should create read and write access control lists (ACLs) on the Multilevel Pivot Rule [sys_report_mpivot_rule] table.
  2. In the Multilevel Pivot Rules dialog box, select New rule.
  3. Fill in the fields on the form.
  4. Select Submit to save the rule and create another rule, or select OK to save the rule and return to the Report Designer.