XLGL Account number including department

Hello all.

Sage 50 has an income statement report that shows departments as rows. Does anyone know how to replicate this with XLGL? We do not want each department in a separate column (which is what we get using a departmental income statement.)

We had designed a custom report with Intelligence Reporting that used this layout with some additional fields, but we haven't been able to copy it with XLGL.

Thank you!