SSRS can only display and do calculations on data that is provided to it.  If you want the subtotal and totals, you will need that data pulled into SSRS.

There...

Otherwise, is there is way to make it so that the year rows on the left appear directly next to the manager, store, branch and hourly rate? When I create...

A column group does not give the result I am looking for. What I am looking for is where next to each manager, store, branch and hourly rate, there are...

I was able to get it to work by creating a separate table off to the right grouping and sorting by the same field(manager). However, it is not aligning with...

• This reply was modified 4 years, 3 months ago by  meddojeddo.

But even when I keep it in the same row as in the first one but move it to a new column to the right, it only displays one year...

• This reply was modified 4 years, 3 months ago by  meddojeddo.