1. Designing with Reports for Oracle Enterprise Performance Management Cloud
  2. Working with Grids
  3. Working with Conditional Formatting, Text, and Suppression
  4. Conditional Suppression Example

Conditional Suppression Example

In this example, we will set up a conditional suppression that suppresses all Region rows where Actual revenues are less than $1,000,000.

The original grid is displayed in Figure 4-35.

Figure 4-35 Conditional Suppression Example, Original Grid


screenshot displays a grid with actual and plan revenues by region. Actual column has 19 entries, 2 of which are less than 1 million.

In the grid editor, select row 1, and then click conditional properties to create the conditional suppression. For details about creating conditions, see Creating a Condition.

screenshot shows grid with row 1 highlighted

Figure 4-36 shows the condition to create, with Data Values in column A less than 1,000,000.

Figure 4-36 Conditional Suppression Example, Condition


screenshot shows a formula named Lower Sales Regions with Data Values in Column A < Value 1,000,000.

When you apply the conditional suppression, the rows with Actual data values less than 1,000,000 are no longer displayed:
screenshot shows a grid with Actual and Plan revenues. Actual column has 17 entries, all of which are over 1,000,000.