I have a report called Open Incident Agining. This report gets run every month and then sent to the associated manager of the assignment group. What I have been trying to do, unsuccessfully is automate the report generation for each Assignment group manager. What the report should look like is filtered by the Assignment group manager(field is column K), then by Assigned To (column L) broken out by aging category (column c) and then list all of the outstanding tickets (column a) within each aging category.
My desired state would be to have a script that can be run on the imported report every month and separate files created for each Assignment Manager. That way each file can be emailed to the assignment group manager directly.
Any help or direction would be greatly appreciated. I have attached the spreadsheet of the raw data.