Using Pivot Tables for analysis

Excel PivotTables can be interesting and useful when you want to analyze Project earned value data. The PivotTable is an interactive table that summarizes large amounts of data in a cross-tabular format. When you use Project to create a PivotTable in Excel, you get two PivotTables in the same workbook a Task PivotTable and a Resource PivotTable. The Task PivotTable shows resources, tasks to which the resources are assigned, and costs for the resource per task. The Resource PivotTable summarizes...