SSRS- Need help with grouping by multiple columns

• kingankit2006

  SSC Veteran

  Points: 267

  More actions

  July 28, 2014 at 7:34 pm

  #289075

  OK so I have a report that I need to hand over tomorrow, so any quick responses will greatly be appreciated!

  I have been working on this the whole day and still haven't been able to figure it out, partially because I am a beginner at this.

  Here is my scenario:

  I have a matrix report that returns something similar to the following data:

  ProjectName, EmployeeName, SalaryStatus, TotalWorkHours, NormalizedHours, Week1, Week2, Week3, Total, Costs/Paid

  01-ABC, Mark, Exempt, 100 (this is derived from adding up the total hours for each week), 10,10,10, 30 $1500

  01-ABC, Tom, Exempt, 80, 20,10,10, 40 $2000

  01-ABC 180, 70 <<<<<<<<<<<<<<<<<<<<<<TOTALS for specific project

  02-XYZ, Rick, Non-Exempt, 90 20, 20, 20 60 $900

  02-XYZ, Grace, Exempt, 30 10, 20, 10 40 $1000

  02-XYZ 120, 100

  So what I really need help with is deriving the TotalWorkHours for each project and employee but my groupings are not working correctly.

  Also a plus point would be to be able to add up the normalized hours for the week with a total column as well. Please ask me if this is not clear enough. Thank you.