Hi Lara, That's an interesting report you've described. At first, I didn't believe it would be possible, but as I mulled it over a bit, now think I might have a solution to offer. First, for background, I'd invite you to read about:
"https://support.workfront.com/hc/en-us/articles/217170837-Creating-a-Matrix-Report">Matrix Reports
"https://support.workfront.com/hc/en-us/articles/216668578-Understanding-Task-Statuses">Task Status
"https://support.workfront.com/hc/en-us/articles/216636328-Understanding-Progress-Status-of-Tasks">Task Progress
"https://support.workfront.com/hc/en-us/articles/216598108-Working-with-Prompts">Report Prompts
With those concepts in hand, I'd then suggest you create a Task Level Matrix Report with settings to:
View the Project Manager Name, Project Name, Project Status
Filter for Projects that are "closed or open, level 1 & level 2"
Group Rows by Project Manager, Project
Group Columns by Task Status, Task Progress
(Optional) Prompt for Project Manager, and/or Task Entry Date
The latter would (for example) allow you to look at "Doug's stats on Tasks entered between Jan 1, 2017 and Dec 31, 2017". You might also consider Group Columns by Task Entry Date (to the Year), then by Task Status, Task Progress, for comparative purposes. Regards, Doug P.S. BONUS: this would make an interesting chart, too: by PM (e.g. Doug, Lara, etc.) and Task Status (e.g. Open, In Progress, Closed) along the x-axis, stacking the number of Tasks that by Task Progress (e.g. On Time, At Risk, Behind, Late) Doug Den Hoed - AtAppStore Got Skills? Lend a hand!
https://community.workfront.com/participate/unanswered-threads