View Single Post
 
Old 08-23-2016, 07:04 AM
JulieS JulieS is offline Windows 7 64bit Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Start with the Budget Work Visual Report


Select Level of usage data = Weeks.
Click View to create the report and export the data to Excel.
Click the Assignment usage tab in the Excel spreadsheet to see the Pivot table
In the Pivot Table field list, click Resources to add Resources to the list.
Drag Tasks from the Filters area into the Rows area after Resources
Right click on one of the tasks and select Show Properties in Report. Select Scheduled Start and Scheduled Finish to show the dates of the task
Drag weekly calendar to Columns
Uncheck Actual work, Baseline Work, and Budget work to see just Work.
Hide columns as needed.

You can also get very close to the Who Does What report by printing the Resource usage view. As needed add the Start and Finish dates to see when the work occurs.
Reply With Quote