Crosstabulate resources and tasks

[Valentin Stanescu]

Can anyone tell me how to see a summed hours
crosstabulation of resources on every MAJOR task?
This may seem simple but if the resources are not
allocated directly on the tasks but rather on the subtasks
the program does not seem to know how to sum them up. Or
maybe I don't know how to do it...
It seems that the entire phylosophy behind the program is
that one should see either the tasks OR the resources.
Even the custom fields with the same names are different
when reffering to tasks or resources.

Thanks in advance )

 

[JulieD]

Hi Valentin

there may be a way to do it in project, but i use Jack Dahlgren's Export
Hierachy to Excel macro (http://www.masamiki.com/project/macros.htm) and
fiddle around with the outcome and create a pivot table from it for this
type of report.

Once you've exported the data to excel, copy the summary tasks down the
relevant rows, convert the work to hours (bit messy, let me know if you need
help on this) and then delete all columns except the summary column,
resource name & work.

Hope this helps
Cheers
JulieD