Group reconciliation: show sub-segment elements and their balances in a report

Summary:

Prospect will have group reconciliations. A report is needed where alongside the group recon balance users can see the associated sub-segments and their balances (sub-segment balances that make up the group balance).

I checked the "Reconciliation Balances" view in the Reconciliations tab but only group balances are displayed.

I also had a look at the ARCS database structure - to see if a custom report could be built - but I am struggling to understand columns/tables where the grouping gets handled. I am happy to understand if it is possible to create a custom report for this and if other customers have done it.