Lesson: Suppressing Missing Values

  To suppress rows that contain missing values from being displayed in the worksheet:

1. In cell C3, double-click the secondary mouse button to drill up on Profit.

2. Pivot Measures (in cell C3) to Actual (in cell D1).

3. In cell B4, drill down (double-click) on product 100.

   In the South member group, the product 100-30 row contains all missing values, indicating that this product is not sold in the South. Scroll down the worksheet to see this row:

   

4. Select Essbase, and then Options.

5. In Display, under Suppress, select #Missing Rows, and then click OK.

6. Select Essbase, and then Retrieve.

   After you change a worksheet option in the Essbase Options dialog box, you must perform a retrieval or drill operation for the setting to take effect.

   Essbase suppresses product 100-30 from the South member group.

   

7. Select File, and then Close.

   Do not save the worksheet.