Suppress Null Values in Views

You can select whether to include null values in an analysis when an entire row or column contains all null values. By default, null measure values are suppressed for all analyses.

For example, you might decide to display null values in the Revenue column of a Sales analysis.

  1. Display the Results tab for the analysis that includes the view.
  2. Click View Properties.
  3. Select the appropriate Include Null Values options for the view.

    For example, suppose that you want to turn off null suppression for both rows and columns in a pivot table. Select Include rows with only Null values and Include columns with only Null values.

    This setting displays corresponding dimensions that have data, as well as null values. Note that if the view contains prompts or section edges, then they also inherit the null suppression value from either the row or column edge.

    Note:

    Turning null suppression off might increase the volume of the data returned and impact performance. Contact your administrator for additional information.

    If results for analyses that include null values aren’t as you expect, then contact your administrator. Verify that data in your sources is consistent.