How would you create a matrixed P&L?

Hello, 

I just went through a painful process of manually creating ~230 lines in a custom row set to go along with 14 columns created in a column set to effectively create a matrixed P&L. The client wanted to have everything on one report and have everything above ‘Gross Profit’ broken down between their divisions (they have 4) as well as showing a total column, and repeat this to show a monthly set and a year to date set on the same page. The rows needed to show all of the correct header column data in a single row and the merge worked pretty well. 

This was my novice approach at this task but how would you have created something like this?