nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Double Suppression on protected Characteristics

Su Ma

Hi,

I’m not sure if this is the right forum to post my question. If not, could you please direct me to the appropriate forum?

I’m currently trying to apply double suppression in a pivot table using conditional formatting for Protected Characteristics and running into an issue.

For example:

If there are 3 Females and 6 Males, both values should be suppressed (i.e., show icons only) because one of the value is < 6, but the total should still display as 9.
In another case, such as Religion with 4 attributes, if 2 values are less than 6 and the other 2 are greater than 6, I would like:
- Values < 6 → show icon only
- Values ≥ 6 → show the actual number
- Total → should be the sum of all attributes

I attempted to implement this using conditional formatting (rule: if value < 6 → show icon only). However, when I apply this rule, the values greater than 6 are showing as blank instead of displaying the number (please see attached screenshot).

Could you please advise if there is a way to configure this so that:

Values < 6 show icon only, and
Values ≥ 6 continue to display the actual value?