Pivot Table for Time Analysis

The Pivot table has some good features, but is not usable for Time Analysis.

  • Filter by Resource (Can be done)
  • Weeks as Columns (Can be done)
  • Projects as Resource (Can be done)
  • Individual Cell is the Hours spent by the resource on that project (Can not be done. Currently Pivot table lumps all the time in the time bucket the task was CREATED. A Task may be created in Week 1; but time against that task entered in Week 1, Week 2, Week 3, etc. Week the Hours were captured needs to be used for the calculation of date for each of the individual cells)