How would I create a pivot table report on opened incidents for the year, sorted by assignment group and months?

[booher04]

I have created a Trend Chart for opened incidents for this year that is sorted by assignment groups and months, but I am having trouble being able to get this information into a Pivot table.   Does anyone have any idea on how to do this?   I have to do this for opened incidents and then do one for closed incidents as well.   I appreciate any insight.  

[Mike Allen]

I don't think you can do this through the report module at this moment.   Maybe you could do a Custom Chart and get what you want?

[manikorada · Accepted solution]

Jeff,

Check these link which might be helpful:

Creating Pivot Tables - ServiceNow Wiki

Pivot table - Incident Category by Month report