# report matrix grand totals in merged cells

• ### Question

• Hello all,

I have a matrix report that looks something like this:

 Total Total Total Total Total 75 106 189 152 17 98 133 248 188 18 77% 80% 76% 81% 94% High Touch I High Touch II High Touch III Bathroom Surfaces Equipment/Other Bedrail ER Bedrail IV Pole Tray Table BS Table NrsCallRemte Telephone Chair RM Doorknob RM Light SW Rm Sink RR DoorHandle RR Flush Handle RR Handrail RR Light SW RR Sink RR ToiletSeat IV Pump Cont Monitor Cont Monitor Scrn # of Surfaces Cleaned 24 0 10 41 37 11 58 51 49 51 38 9 15 37 45 36 10 1 7 9 # of Surfaces Evaluated 30 2 11 55 41 18 74 88 58 58 44 10 15 51 53 48 11 1 8 9 % of Surfaces Cleaned 80% 0% 91% 75% 90% 61% 78% 58% 84% 88% 86% 90% 100% 73% 85% 75% 91% 100% 88% 100%

But the customer wants it to look more like this:

 Total # of Surfaces Cleaned 75 106 189 152 17 Total # of Surfaces Evaluated 98 133 248 188 18 Total % of Surfaces Cleaned 77% 80% 76% 81% 94% High Touch I High Touch II High Touch III Bathroom Surfaces Equipment/Other Bedrail ER Bedrail IV Pole Tray Table BS Table NrsCallRemte Telephone Chair RM Doorknob RM Light SW Rm Sink RR DoorHandle RR Flush Handle RR Handrail RR Light SW RR Sink RR ToiletSeat IV Pump Cont Monitor Cont Monitor Scrn # of Surfaces Cleaned 24 0 10 41 37 11 58 51 49 51 38 9 15 37 45 36 10 1 7 9 # of Surfaces Evaluated 30 2 11 55 41 18 74 88 58 58 44 10 15 51 53 48 11 1 8 9 % of Surfaces Cleaned 80% 0% 91% 75% 90% 61% 78% 58% 84% 88% 86% 90% 100% 73% 85% 75% 91% 100% 88% 100%

I can make row groups and transpose the values into them, but the cell needs to span the width of the column group -- which can be any number of columns (otherwise, I wouldn't use a matrix).

I'm thinking this is impossible, but I thought I would ask.