I would like to track the project status of several projects with a weekly report and keep track of all project history and status with a pivot table summing-up all the data from the weekly reports.
The weekly report would be something like the following:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Project[/TD]
[TD]Activity[/TD]
[TD]Hours[/TD]
[TD]% Complete[/TD]
[/TR]
[TR]
[TD]week 1[/TD]
[TD]101[/TD]
[TD]Design[/TD]
[TD]20[/TD]
[TD]30%[/TD]
[/TR]
[TR]
[TD]week 2[/TD]
[TD]101[/TD]
[TD]Design[/TD]
[TD]10[/TD]
[TD]50%[/TD]
[/TR]
[TR]
[TD]week 3[/TD]
[TD]101[/TD]
[TD]Design[/TD]
[TD]5[/TD]
[TD]65%[/TD]
[/TR]
[TR]
[TD]week 4[/TD]
[TD]101[/TD]
[TD]Design[/TD]
[TD]9[/TD]
[TD]75%[/TD]
[/TR]
[TR]
[TD]TOTAL[/TD]
[TD]101[/TD]
[TD]Design[/TD]
[TD]44[/TD]
[TD]75%[/TD]
[/TR]
</tbody>[/TABLE]
How can I set up the formula for the weekly report to provide only the %Complete of that week minus the %Complete for he same activity last week
or
Set up the pivot table to only show the latest value of the % Complete field. I have tried to use the "Difference From" function, however it will not summarize the values for each activity.
Can some one give me an idea how to do this?
Regards,
Sergio Cantu
The weekly report would be something like the following:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Project[/TD]
[TD]Activity[/TD]
[TD]Hours[/TD]
[TD]% Complete[/TD]
[/TR]
[TR]
[TD]week 1[/TD]
[TD]101[/TD]
[TD]Design[/TD]
[TD]20[/TD]
[TD]30%[/TD]
[/TR]
[TR]
[TD]week 2[/TD]
[TD]101[/TD]
[TD]Design[/TD]
[TD]10[/TD]
[TD]50%[/TD]
[/TR]
[TR]
[TD]week 3[/TD]
[TD]101[/TD]
[TD]Design[/TD]
[TD]5[/TD]
[TD]65%[/TD]
[/TR]
[TR]
[TD]week 4[/TD]
[TD]101[/TD]
[TD]Design[/TD]
[TD]9[/TD]
[TD]75%[/TD]
[/TR]
[TR]
[TD]TOTAL[/TD]
[TD]101[/TD]
[TD]Design[/TD]
[TD]44[/TD]
[TD]75%[/TD]
[/TR]
</tbody>[/TABLE]
How can I set up the formula for the weekly report to provide only the %Complete of that week minus the %Complete for he same activity last week
or
Set up the pivot table to only show the latest value of the % Complete field. I have tried to use the "Difference From" function, however it will not summarize the values for each activity.
Can some one give me an idea how to do this?
Regards,
Sergio Cantu