Show summery complete to each milestone

[Kimosabi]

I've heard this is not possible in Microsoft Project. I would like the progress bar that is within my summery bar to stop at the last complete milestone (which has been rolled up to the summery bar). As it stands, Project will only add up the percentages complete and apply an overall average completion to the summery bar. I have the milestones showing complete when they are designated as 100 percent, but I would like the progress bar within the summery bar to be based on those completions. Any way possible?

 

[Kimosabi]

I'm answering my own question on this one. Finally figured it out. You create a "Finish 1" column and name it something like "Complete To" for your own convienience. Once its created you go into the "Customize Fields" setup- (a right-click will get you there). In the Customize Fields setup, you set Finish 1 to "rollup maximum" using the buttons at the bottom of the window, and a pull down menu there. You also set an "If" formula for the Finish 1 fields so that they reflect the regular Finish date, if the milestone is 100% complete. You then set your "Bar Styles" under the Format menu, so that rolled up progress begins at the start date, and ends at the Finish 1 column date.

It works well. I know a lot of folks would like to know this one.

 

[BHBPCP]

Hi,

I have tried to recreate this but have had no joy. Could you copy a couple of phases into a balck project so I can see how you did it. I'm at trevorroberts@hsbc.com. Obviously, kill off any sensitive stuff but I think what you have described is what I am tryign to do.

Regards,

Trevor