Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Suppressing Header Labels or Total Rows

In your report, you’re likely to have rows that you’ve added manually — using Excel functionality — to clarify or expand on Adaptive data. Typical examples are header labels above Adaptive Planning data or total rows below Adaptive Planning data.

Although these rows are not Adaptive Planning data, you can associate them with Adaptive elements. Then if you want, you can specify that when data below header labels or above total rows are all zero, those header or total rows should be hidden. This ensures that your report doesn’t look like it’s missing information when zero rows and columns are hidden.

To hide a header label or total row:

  1. If necessary, on the OfficeConnect tab, in the Show group, click Suppress Zero to turn it off.

  2. When you create a new OfficeConnect workbook, the Suppress Zero command is off by default.

  3.  Select the header label or total row that you want to hide if its data is all zero.

  4. Click Label Suppression from the Design group in the OfficeConnect tab.
    The Label Suppression dialog appears.

  1.  Click in the Label Row 1 box.

  2. In the grid, select the area that contains Adaptive metadata that you want to associate with your selected header label or total row.

The cell range of the selected area in the grid, for example, B5:E13, appears in the Label Row 1 box. If you prefer, you can also type the cell range in the box.
You can also select rows, or type a range such as 2:8 to represent rows 2 through 8:

If you want to suppress header labels or total rows for multiple cell ranges or rows, click in the Label Row 2 box, and then select the second cell range or set of rows. Continue entering ranges in succeeding Label Row boxes as needed.

  1.  Click OK.

  2. On the {{oc}} Design group, click Refresh.

  3.  On the OfficeConnect tab, in the Show group, click Suppress Zero to turn it on.
    The header label or total row you associated with any zero rows or columns is now hidden.

  • Was this article helpful?