Spotfire Cross Table two Grand Totals, Different Aggregates

I am using Spotfire 7.0, I am using a Cross table to display a standard Income statement with Accounts on the left and Months across the top.  


I would like to show the Sum in the cells and then have an Average over the 12 months as the last column, as a bonus I would also like the Sum over 12 months. I don't believe I can use a Pivot as my cross table is changing dynamically as parameters change and there would be a time penalty too.


In summary I can't seem to combine different aggregate types in the Cells and the Grand Total, does anyone have any ideas? 


ps. Does anyone know how to show negative text values in red in a Cross Table? 


Thanks in advance.

(1) Answer