I am trying to create an file, preferably excel pivot table, which would look like the resource usage view. It would contain a list of resources from a defined group and list the WBS codes and task names they are assigned to and then give a week by week breakdown of the remaining work (or % assigned) for each task. Even better would be if I could specify the period of time (a 8 week window say).
Does anyone know how I might do this?
Does anyone know how I might do this?