Cross tab totals

[Gwynhwfar]

I have set up a cross tab which has two subcolumns for each column. I want the grand total for each row to total the subcolumns and show me that rather than an overall total:

getting:

+ col1 + col2 + total +
+ sub1 . sub2 + sub1 . sub2 + +
row 1 + 3 . 2 + 1 . 5 + 11 +

what I want is:
+ col1 + col2 + total +
_____________+ sub1 . sub2 + sub1 . sub2 + sub1 . sub2 +
row 1 + 3 . 2 + 1 . 5 + 4 . 7 +

Is there an easy way of doing this?
Thanks
Lez