sql - SSRS 2008 display mutilple columns of data without a new line -

i creating report in ssrs 2008 ms sql server 2008 r2. have data based on aggregate value of medical condition , level of severity.

outcome response adult youth total bmi         70    0     70 bmi     monitor  230   0     230 bmi     problem! 10    0     10 ldl         5     0     5 ldl     monitor  4     0     4 ldl     problem! 2     0     2 

i need display data based on response like:

      bmi   bmi     bmi        monitor problem! total 70    230     10 youth 0     0       0 adult 70    230     10        ldl   ldl     ldl         monitor problem! total 5     4       2 youth 0     0       0 adult 5     4       2 

i first tried use ssrs grouping based on outcome , response got each response on separate row of data need outcomes on single line. believe pivot work examples have seen pivot on 1 column of data pivoted using another. possible pivot multiple columns of data based on single column?

with existing dataset similar following:

create list item, , change details grouping based on outcome:

in list cell, add new matrix 1 column group based on response:

you'll note since have individual columns total, youth, adult, need add grand total rows display each group.

the end result pretty close requirements:

for underlying data, report development might useful have total, youth, adult unpivoted columns, it's not big deal if groups static.