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

Displaying Row Labels In A Template Report

Question

I would like to be able to see labels for all rows and columns in an excel template report. Is this possible? At the moment I can only see all the labels for 1 column.

Answer

With standard functionality, all labels are currently displayed on the inner most column element on a template report, and just for the rollups for other columns. However, it is possible to have labels repeat for all columns by using a macro.

As an example, let’s say we currently have a report that looks like this;

To enable the Level names to be repeated for Levels (Column A) we need to create a macro (in this case called FillEmpty) with the following;

Sub FillEmpty()

  Application.ScreenUpdating = False

  Application.Calculation = xlManual

  Dim cell As Range

  For Each cell In Intersect(Selection, _

            ActiveSheet.UsedRange)

    If Trim(cell) = "" And cell.Row > 1 Then

      cell.NumberFormat = cell.Offset(-1, 0).NumberFormat

      cell.Value = cell.Offset(-1, 0).Value

    End If

  Next cell

  Application.Calculation = xlAutomatic  'xlCalculationAutomatic

  Application.ScreenUpdating = False

  End Sub

 

Then highlight the column where you want to make the change (multiple columns can be selected if necessary) and run the macro. The report will then look like this;

For additional information on using report templates, please take a look at the following link: Best Practices For Creating Templates.