Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

S curve - cumulative cost vs actual cumulative cost

Status
Not open for further replies.

andrewintown

Technical User
May 21, 2009
2
0
0
CA
Using the Visual Reports function in Project 2007, I can create "S-Curves" using the "Earned Value Over Time" Report.
I want to show "Cumulative Cost" vs the actual cumulative cost.
"Cumulative Cost" is based on "Cost".
My actual cumulative cost would be the sum of "Actual Cost" over the time period.
This then would produce an s-curve of cumulative cost planned vs actual.
Currently I only get "Actual Cost" as a week by week breakdown, but can't get it to sum.
Is there an easy way to do this using the Visual Reports output to an Excel pivot table?
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top