Hiding Rows or Columns Having No Data or Zeros

  To hide rows having no data or containing zeros:

1. Put the cursor on a row member name and right-click.

2. Select:

   • Hide rows with no data: to toggle between hiding and showing rows having no data (displayed as #MISSING or blank, depending on how your administrator set this data form property). This option does not display if your administrator has set the data form's property to Suppress Missing Data.

   • Hide rows with zeros: to toggle between hiding and showing rows having zeros for values.

   • Hide rows with zeros and no data: to toggle between hiding and showing rows having either no data or zeros, or both.

3. To switch between showing and hiding rows, select the option again.

  To hide columns having no data or containing zeros:

1. Put the cursor on a column member name and right-click.

2. Select:

   • Hide columns with no data: to toggle between hiding and showing columns having no data (displayed as #MISSING or blank, depending on how your administrator set this data form property). This option does not display if your administrator has set the data form's property to Suppress Missing Data.

   • Hide columns with zeros and no data: to toggle between hiding and showing columns having either no data or zeros, or both.

3. To switch between showing and hiding columns, select the option again.