Resource Summary Report

Hi,

 

relatively new to P6 and want to run a report that is similiar to the Resource Assignment. 

I have grouped my resources into different categories using Resource levels ie. Lvl 1 = Department, Lvl 2 = Department Breakdown, Lvl 3 = resources.

like image below

 

capture1.jpg

 

What I want to do is produce a report to look the same, however I cannot get the totals to summarise.

See report below

capture2.jpg

I have tried all sort od Total / Suammry check boxes, but can get this to work.

 

Anyone have any Ideas?

 

Thanks

 

D
Duncan Pirie 👤 Member for 13 years 8 months

Thanks Jean,

I have been copying the reources into excel.  The only thing wrong with that is that it seems to copy the entire project i.e. from start to end date, so end up having to delete all the columns from excel.  Not a major thing, but just thought the report would be easier - If I could get it to work.

Many Thanks for your reply though.

 

Duncan

J
Jean Desjardins 👤 Member for 14 years 7 months

Hi Duncan,

An option is to copy your informations with "Ctrl A" and paste it in an Excel spreadsheet.

Meanwhile, you will have to format your spreadsheet.

Jean

Forum Sponsor

Top Posters

Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts