Subtable drill-down
Subtable is a way exposing additional details inside a report without adding all the details to the main view. Once configured the user can easily expand specific row to reveal more details.
Aggregate one or more columns using StringContact aggregator. The key is to have lists of values of the same length.
Add Custom Formula labeled SubtableHeaders. Custom formula must return list of column aliases containing the lists.
Enable subtable in the report options
Default subtable will be generated after refresh
To change the order of columns in the subtable change the alias order in the SubtableHeaders formula.
To add custom captions to subtable columns add another custom formula labeled SubtableCaptions with list of labels you want to appear in the subtable.