JulieD
Mon Sep 06 08:04:52 CDT 2004
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
"Valentin Stanescu" <vstanescu@yahoo.com> wrote in message
news:677601c493df$64276530$a601280a@phx.gbl...
> 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 :))
>