Hiding Rows or Columns Having No Data or Zeros

  To hide rows having no data or containing zeros:

  1. Right-click a row member name, and then select Filter.

  2. Then 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 form property). This option is not displayed if your administrator has set the 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, follow the procedure for rows, but select columns instead of rows.