Tabular Expanded Matrix with column Grand Totals

Hi,

I would like to use a matrix, so that i am able to have fozen columns for a table with many columns. however when i switch this to a tabular form, and expand to the lowest level the totals at the bottom of the matrix dissapear.

is there anyway to maintain column grand totals in this way, or do i have to pick between totals on a table but with no frozen pane, or frozen pane on a matrix with no totals?

Thanks