Thank you for the reply. However i cannlot find the monthly field in my task usage section of th pivot table.
I have about 4 medium sized projects for this year. I already have activities defined and scheduled.I have also defined cost resources and assigned them to the activities taking place through the year.
Now i need to show to the management what are the likely cost to hit in which month. So i need a graphical representation or a spreadsheet that shows the activity name along the Y axis, the months on top (as the gant chart) and the cost showing throughout the chart with the total refelecting month wise.
I hope you can imagine what I need to express to the manangement.
well im facing the same problem you faced about 2 years ago. But if you've found the soultion, id be delightedif you shared it. I want the same oriientation.....X axis as months and the cost intervala along the Y axis.
Spider Project is most functional and powerful professional project management software.
The first SP version was launched in 1993 and since then it has been constantly improved. Today is used in 34 countries though most Spider Project customers are in Russia. Spider Project offers numerous unique functional features and is the only PM software that optimizes resource, cost, and material constrained schedules and budgets for projects and portfolios.
The unique features of Spider Project include Quantity Based Scheduling, Conditional Scheduling, Skill Scheduling, Optimal Resource, Cost and Material Leveling, Resource Critical Path Calculation, Cash and Material Flows Calculation and Management, Trend Analysis, Advanced Risk Simulation and Analysis, Calculation of Success Probability Trends, Calculation and Management of required Project Time and Cost Buffers, Application of Corporate Norms, Management of many Parallel Budgets, Multiple WBS and many others.
Spider Project was and is used for management of many large scale programs in Russia, including $51bln construction program for 2014 Winter Olympic Games preparation.
The application areas where Spider Project is successfully used include Aerospace, Banking, Construction, Defense, Energy, Engineering, Infrastructure, Manufacturing, Metallurgy, Mining, Oil & Gas, Railways, Retail, Shipbuilding, Software Development, Telecommunications, Utilities, etc.
P6-Auditor - Display information from Primavera P6 audit tables in a user-friendly format
Unifier-Archiver - Extract and archive important documents and attachments from Primavera Unifier
Unifier-Loader - Load data into and out of Unifier via Excel
PCM-Loader - Import data into Primavera Contract Management with flexible and secure, template-driven Excel spreadsheets
PCM-Archiver - Extract and archive important documents and attachments from Primavera Contract Management
PCM-Unifier Migrator - Automatically transfer live and historical data from Primavera Contract Management to Primavera Unifier with ease
Create Radically Better Construction Schedules with ALICE Technologies
Use the power of AI to create construction schedules that reduce risk while cutting costs and build time. With ALICE, develop the ideal schedule during preconstruction -- or recover projects that are off schedule and over budget.
[[wysiwyg_imageupload:356:]]
Abdullah, hope this can help you
Hey Mathew,
Thank you for the reply. However i cannlot find the monthly field in my task usage section of th pivot table.
I have about 4 medium sized projects for this year. I already have activities defined and scheduled.I have also defined cost resources and assigned them to the activities taking place through the year.
Now i need to show to the management what are the likely cost to hit in which month. So i need a graphical representation or a spreadsheet that shows the activity name along the Y axis, the months on top (as the gant chart) and the cost showing throughout the chart with the total refelecting month wise.
I hope you can imagine what I need to express to the manangement.
Regards,
Abdullah.
One more thing, pls ungroup the Year field after the drag
Hi Moutaz and Abdullah,
Tips for your referance,
- Select level of usage as Months, then View, as you usually do
- Go to Task Usage sheet of the report
- At the end of PivotTable Field list, select Time Fields
- Then in the Drag Field, move Time Monthly from Column Labels to Row Labels
- Check your chart
Good luck,
Hi, Moutaz,
well im facing the same problem you faced about 2 years ago. But if you've found the soultion, id be delightedif you shared it. I want the same oriientation.....X axis as months and the cost intervala along the Y axis.
Regards,
Abdullah.