I have 6 types of tickets, Onboarding and offboarding, IT purchase, Infrastructure IT Support and project.
For all the other tickets I can easily tell why calls are slightly higher or lower, but the IT support one we have differences of 60-100 per month.
I want to be able to just break it down, we have 13 headings under IT support, how can I just run a report against those and just have the subheading from below come up?
I am a SQL dummy, I can bodge things together and sometimes make them work but I think this requires knowledge and finesse, SQL skills I am severely lacking.
I have this script that I thought I could modify to add the additional info from IT support, but I don't have the ability to amend to this code.
,
Select Top 1000000 DatePart(yyyy, htblticket.date) As Year,
  DatePart(mm, htblticket.date) As Month,
  htbltickettypes.typename Type,
  htblusers.name As AssignedAgent,
  Count(htblticket.ticketid) As TicketCount
From htblticket
  Inner Join htblagents On htblagents.agentid = htblticket.agentid
  Inner Join htblusers On htblusers.userid = htblagents.userid
  Inner Join htbltickettypes On htbltickettypes.tickettypeid =
    htblticket.tickettypeid
Group By DatePart(yyyy, htblticket.date),
  DatePart(mm, htblticket.date),
  htbltickettypes.typename,
  htblusers.name
Order By Year Desc,
  Month Desc,
  Type,
  AssignedAgent
I tried modifying this script from 
here, but failed miserably.
Could anyone show me the light please?
As always, thanks in advance.
Tim