Creating and Drilling Down into Report Matrix Data

WestOderman

In this example, add a matrix to a report, run the report to view the matrix. Then, select a cell in the matrix to view the drill-down report.

1 Begin in the portal by navigating to a Designer Folder. Select the Create Report button in the bottom action panel. In the resulting dialog, give the report a name and select Create.

2 In the Report Designer, define the data source from Data Sources > Common then choose Folder Data Source. Then under the Data Fields column and add Entity Name, Folder Type Name, and Nesting Level to the report.

from: https://documentation.decisions.com/v9/docs/drilling-down-into-report-matrix-data-2