Problem
Most Severely Over Time Project Before creating the pivot table, add another column to the data set, one that calculates the difference between the actual project time and the estimated project time. Then create a pivot table and include the new column in the pivot table. Note: If you have already created a pivot table in the worksheet, without the new column, you may need to refresh the pivot table [Pivot Table Tools/ Options/Refresh] to see the new column listed in the Pivot Table Field List.
a. Which project manager has had the project that went most severely over the estimated project time?
b. How many weeks over time was the project?
c. Was the project over budget as well?