Running and analyzing dashboards, documents, and reports » Analyzing report and document results » Determining how null and zero metric values are displayed or hidden in a grid report

Determining how null and zero metric values are displayed or hidden in a grid report

You can determine how to display or hide rows and columns in a grid report 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 nulls and zeros using the Hide Nulls/Zeros option in the Data menu, as described below, or by clicking the Hide Nulls/Zeros icon Hide Nulls/Zeros icon in the Data toolbar.

Prerequisite

You have already created a grid report.

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

This procedure applies to reports; for steps to determine how null values and zero values are displayed or hidden on a grid report in a document, see the Document Creation Guide.

1 Click the name of the report to open it.
2 From the Tools menu, select Report Options. The Report Options dialog box opens.
3 To determine how MicroStrategy hides null and zero metric values in the grid, on the General tab, 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.

To show or hide null and zero metric values in a grid report

1 Do one of the following:
For a report, click the name of the report to open it.
For a document, open the document that contains the report in Editable Mode.
2 Click the grid to select it.
3 On the Data toolbar, click the Hide Nulls/Zeros icon Hide Nulls/Zeros icon to switch between showing and hiding rows and columns containing null metric values.
To display the Data toolbar, click Data on the menu bar.