Re: How to calculate weekly total by John
John
Wed Jun 13 10:15:37 CDT 2007
In article <1181742659.637876.170740@j4g2000prf.googlegroups.com>,
FiachraFiachra@gmail.com wrote:
> Hi,
> Has anyone a way of showing on the usage table a total for the
> combined resources on a weekly basis?
> Basically, what I have is a table of all resources using peak units
> and require a weekly total on this at the base of the table eg:
>
> 1 CARPENTER 1,823hrs 1 1 2 3 3 5 5 5
> 2 JOINE 567hrs 1 4 4 3
> .
> .
> .
> .
> (Here i want TOTAL) (1) (2) (6)
> (7) .........................
>
> any suggestions...?
Fiachra,
The only way to get the exact format you want is to use VBA to export
the data to another application (e.g. Excel). As an alternative you
could try the "Analyze timescale data in Excel" utility found on the
Analysis toolbar. Run it from the Resource Usage view.
However, you can get a report that will be very close to what you want
by setting the timescale on the Resource Usage view to be weeks. The
format in your post doesn't come through very well when I view it so I
don't know exactly what is being summed up but you might need to also
use Project's grouping function (Project/Group by/Customize Group by).
Hope this helps.
John
Project MVP