How to sum SSRS Matrix Columns on Row Group (Per specific row group)

(0) Share

Report

Posted on by source258147

1,021

I have a report that displays the total hours a person worked for each project they are assigned to, aggregated on month. I would like to sum the Project 1 and Project 3, for each month, in SSRS. So, for example, I have the follow data and would like to column totals like so:

                    January          February          March
Worker 1
    Project1           50               80               20
    Project2           30               10               60
    Project3           10               40                5
           Total:      60              120               25
Worker 2
    Project1           20               40               60
    Project2           10               30               10
    Porject3           30               10               50
           Total:      50               50              110

my row groups are: