Combine rows in a report

Combine rows in a report

 I have a table that has the following columns:

   
    
    
  1.  DATE  |  TEAM  | PROJECT CATEGORY | WORK COMPLETED | HOURS
    2.

and has data like this:

  
    
   
  1.  DATE  |  TEAM  | PROJECT CATEGORY | WORK COMPLETED | HOURS
    2. 
   
  2. {date}  |  {team}  | Non-Chargeable Work   | Service Request     | 2
    3. 
   
  3. {date}  |  {team}  | Non-Chargeable Work   | Support Incident    | 4
    4. 
   
  4. {date}  |  {team}  | Chargeable Work       | Delivery         | 2
    5. 
   
  5. {date}  |  {team}  | Non-Chargeable Work   | Support Case Mgmt   | 6
    6.

For a report, i would like to combine some of these rows (the bolded above) into a general "support" row, which would look like this:

  
    
   
  1.  DATE  |  TEAM  | PROJECT CATEGORY | WORK COMPLETED | HOURS
    2. 
   
  2. {date}  |  {team}  | Non-Chargeable Work   | Support          | 12
    3. 
   
  3. {date}  |  {team}  | Chargeable Work       | Delivery         | 2
    4. 
  

I can't figure out the best way to achieve this within Zoho - can anyone offer any help?

Thanks!