MicroStrategy ONE

Determining how null and zero metric values are displayed

You can determine how to display or hide rows and columns in a grid that consist only of null or zero metric values. You can have MicroStrategy hide the rows and columns in the following ways:

  • Hide rows and columns that consist only of null metric values

  • Hide rows and columns that consist only of zero metric values

  • Hide rows and columns that consist only of null or zero metric values (default)

Once you have defined how MicroStrategy hides null and zero metric values in the grid, you can quickly show or hide rows or columns in the grid using the Hide Nulls/Zeros option in the Data menu, as described below, or by clicking the Hide Nulls/Zeros icon in the Data toolbar.

Prerequisite

The following procedure assumes that you have already created a grid in a document.

To determine how null and zero metric values are displayed or hidden in a grid

  1. Open the document in Editable Mode.

  2. Right-click the grid, then select Properties and Formatting. The Properties and Formatting dialog box opens. From the left, click Grid.

  3. To determine how MicroStrategy hides null and zero metric values in the grid, select the Hide Null/Zero Toggle Behavior check box. From the drop-down list, select one of the following:

    • To hide rows and columns that consist only of null or zero metric values, select Hide Nulls or Zeroes (default).

    • To hide rows and columns that consist only of null metric values, select Hide Nulls Only.

    • To hide rows and columns that consist only of zero metric values, select Hide Zeros Only.

  4. Click OK to apply your changes, then click the grid to select it.

  5. To determine whether null and zero metric values are displayed or hidden in the grid, from the Data menu, select one of the following:

    • To hide rows and columns containing null metric values, zero metric values, or both as defined in the steps above, select the Hide Nulls/Zeros option.

    • To display all rows and columns in the grid, including those that consist only of null or zero metric values, clear the Hide Nulls/Zeros option.