Ms Project

Hi Agnes

No problem - take a look at the visual reports under the Report menu.

Under the Resource Usage tab double click the Resource Work Summary report.

Excel will open. Don't worry about the chart that appears. In fact right click on the tab Chart1 and delete it. We won't be using it.

You should be left in the pivot data that was used to create the chart. On the lower right side of the screen you will see four boxes labelled Report Filter, Column Labels, Row Labels, Values.

There are already some items in the boxes. Above the boxes is a long list, containing three items that are ticked. Remove the ticks from these items and the pivot table should clear of data.

Now everything is unticked we can add our own selection to the pivot.

In the list find Time Weeklyl Calendar. Right click it and choose Add to column labels.

Find Resources in the list, right click and add to Row labels

Finally right click Work and choose Add to Values.

Now in the pivot table itself click on the little + symbol beside 2010 to open it up. Inside you will probably find Quarters also with + symbols. Give those pluses a click and you will see the committed work for your resources at a weekly level.

Is this closer to the kind of report you are looking for?

If you find pivot tables may be helpful to you then take a look at our Advanced Excel course where we explore them in more detail.
https://www.stl-training.co.uk/excel-2007-advanced.php


Kind regards,
Andrew