Data export to pivot or crosstab

[paolino58]

I m trying to export Project (2003) data to an Excel spreadsheet or pivot
with this format:

- rows: tasks, respecting the hierarchy
- columns: resources (possibly grouped by resource groups)
- data: sum of work

So far, I had no success neither by exporting to Excel nor by using a
crosstab report. Any help is appreciated.

Thanks,
Paolo

 

[Andrew Lavinsky]

Have you tried:

1) Export Timescaled Data to Excel, which is on the Analysis toolbar?
2) Save As, Excel, Custom Map with the Task or Assignment fields: Task Name,
Resource, Resource, Resource Group, Work?

The challenge you will have is with the resources or resource group - making
them into one column each. Project will either concatenate the output as
a Task field, or assign each resource to a row if exported as an Assignment.
If you're clever in Excel, you should be able to get it close to what you're
looking for.

-A