Would like to show total resolved incidents per week by Assignment Group

[scottstahr]

We have a requirement to report on how many incidents an assignment group has resolved per week.   Currently we are tracking this through a trend report on Resolved by week grouped by Assignment group.   Since we have a large number of assignment groups, the bars come out very difficult to read.  

Would there be a way to just print the numbers in a pivot table similar to below?

Assignment Group	1/1/2017	1/7/2017	1/14/17
Desktop Services	5	12	7
Network	4	3	4
Security	10	7	9

If not, we would be satisfied if we could perhaps limit the number of groups on the trend to the top 10 assignment groups.   Is this possible?   Thanks!

[shloke04 · Accepted solution]

Hi,

You can create a Multi Pivot Report as below:

Hope this helps.Mark the answer as correct/helpful based on impact.

Regards,

Shloke

[shloke04]

Hi,

Did you got a chance to Test the Solution provided for your query.

If your query is Resolved, Please mark the answer as correct so that the thread can be removed from the Unanswered list.

Regards,

Shloke