none
report matrix grand totals in merged cells RRS feed

  • Question

  • Hello all,

    I have a matrix report that looks something like this: 

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

    But the customer wants it to look more like this:

    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%
    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%

    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.

    Thank you in advance










    • Edited by trufaux Friday, June 20, 2014 2:51 PM Made the table headers more consistent
    Wednesday, June 18, 2014 9:19 PM