This is the raw data (pretty much).

This is the basic format I would like to create perhaps using Data::Tabular.

Ultimately, I need to markup the data with class names based on the content.  That may take hacking Data::Tabular and adding a new layout type.  I need to have the Total lines be triggers to collapse the sections that they total.  So Collapsing the lowest level in the above table would look like this:

There is a ton of work to do to get everything to this level and there's more.  I'd like the Green Totals in the above table to disappear.  I need to have the ability to expand/collapse one section at a time or all sections on the same level at the same time.  I have prototypes of all of this collapsing stuff in action.  My problem is getting the data from the database or 2d array structures transformed into some sort of format that I can add collapsing to.   It doesn't have to be the same format as in the prototypes.