I have a lot of ticket request types that have sub categories included. What I'd like is just a basic bar chart report that essentially shows where most of our helpdesk work is being spent on. The problem is it seems the reports always include a separate bar for each sub category, this makes the entire report too long and unusable. For example I have a top level category for Printers, then sub categories for scanning, printing, faxing, new procurement, new installations, and general maintenance. In the report the tickets from the sub categories should be combined for the top level Printers category - that way we quickly see how much time is spent dealing with all printing issues.
How can I do this?