Simplified Hours Report for Portfolio, Program, and Projects
We would like to create simple hours reports at each of three different levels (Portfolio, Program, and Project) that simply show total hours in one line item per user (does not expand to show each individual task). Currently when these reports are created, there is a summary but there are also lines for each specific task per user so when the report is scheduled to be sent, the Excel file has way more data than is necessary and manual clean up is required. Has anyone created something similar?
Examples:
PORTFOLIO A
Jane Doe 200 hours
John Doe 150 hours
PORTFOLIO B
Jane Doe 50 hours
John Doe 75 hours
Jim Doe 100 hours
PROGRAM A
Jane Doe 200 hours
John Doe 150 hours
PROGRAM B
Jane Doe 50 hours
John Doe 75 hours
Jim Doe 100 hours
PROJECT A
Jane Doe 100 hours
John Doe 150 hours
PROJECT B
Jane Doe 50 hours
John Doe 75 hours
Jim Doe 100 hours