Great Video Thanks. Wondered if you can explain How to automatically Set the Pivot Table Value Field setting to a default of Sum instead of Count please? Many Thanks Paul
Thank you for your great feedback Paul 🙏 When your spreadsheet data type is a text, then PIVOT create a count, so convert the spreadsheet from text to number then it change to SUM instead of count
Also, how are you dealing with offsetting the start of the remaining unit value, so it starts are the end of the actual valure in the chart i.e. actual runs over 4 months from 0 to 1500 units, remaining starts at 1500 units going to 20,000 units over the remaining project duration🤔
Dear @Mark Wright, you need to compare data by cut off date + in cumulative fields to find the variances, for further information please join the GPC Telegram Group to discuss it 🌍 t.me/GlobalProjectControl
I am happy that it was useful for you, please check below items: 1. If all activity codes assigned to all activities 2. Please check it if you collect the information from "activity Usage Profile" for further clarification please join to Global Project Control Telegram Group : t.me/GlobalProjectControl
You can find all information in this channel, for instance find this video for resource budget hour and cost loading from Excel spreadsheet to P6: 🔴 How to Load Multiple Resources By Excel 🎞 th-cam.com/video/CuKQ3j_iYUQ/w-d-xo.html
Nice video. But the challenge is the actuals. P6 will not respect the historic actuals unless applying actuals. Which has its own down sides.. Let us know whats ur take on this
Good Question! you have 2 below solutions: 1. Keep the previous actual updated information and only import the new data date information. 2. use Financial period
Hello Ahmad It's a very informative video. Thanks for sharing. Also, have one query. Suppose for the activities mentioned in the schedule, there are 2 separate groups A & B, working for each activity, and both have different budgeted labor units for each activity. Now, if I want to see and draw the S-Curve for particularly B group, budgeted units, Curve, what should I do in that Case?? Please let me know. Thank you
Thank you for your comment, I suggest you create two different activity codes and assign them to the activities. Then you can add slicers to the s-Curve and find the curve for each of the activities
@@GlobalProjectControl Thanks for the reply But if suppose there are 10 activities in schedule and all 10 activities in the schedule has been assigned both labor A and labor B with some budgeted units. And now I want to check only for Labor B, so Can we assign Activity code as both of the labor A and B, to the activity
@@rupeshbhattacharya2903 Yes, you can assign the activity codes for different group types A & B, then when you use the filter, it will be updated the result
Great Video Thanks. Wondered if you can explain How to automatically Set the Pivot Table Value Field setting to a default of Sum instead of Count please? Many Thanks Paul
Thank you for your great feedback Paul 🙏
When your spreadsheet data type is a text, then PIVOT create a count, so convert the spreadsheet from text to number then it change to SUM instead of count
very useful
Glad you think so!
Many thanks
You are welcome 🙏
Also, how are you dealing with offsetting the start of the remaining unit value, so it starts are the end of the actual valure in the chart i.e. actual runs over 4 months from 0 to 1500 units, remaining starts at 1500 units going to 20,000 units over the remaining project duration🤔
Dear @Mark Wright, you need to compare data by cut off date + in cumulative fields to find the variances, for further information please join the GPC Telegram Group to discuss it
🌍 t.me/GlobalProjectControl
Hi there very nice video, i am finding that when i use the slicers to filter the chart i lose the cumlative lines, any tips please
I am happy that it was useful for you, please check below items:
1. If all activity codes assigned to all activities
2. Please check it if you collect the information from "activity Usage Profile"
for further clarification please join to Global Project Control Telegram Group : t.me/GlobalProjectControl
Perfect job 👍 like all time good luck
Hey
Sir please make a full video of how to make full baseline with relationship resource and cost loading
You can find all information in this channel, for instance find this video for resource budget hour and cost loading from Excel spreadsheet to P6:
🔴 How to Load Multiple Resources By Excel
🎞 th-cam.com/video/CuKQ3j_iYUQ/w-d-xo.html
Nice video. But the challenge is the actuals. P6 will not respect the historic actuals unless applying actuals. Which has its own down sides.. Let us know whats ur take on this
Good Question! you have 2 below solutions:
1. Keep the previous actual updated information and only import the new data date information.
2. use Financial period
Hello Ahmad
It's a very informative video. Thanks for sharing.
Also, have one query.
Suppose for the activities mentioned in the schedule, there are 2 separate groups A & B, working for each activity, and both have different budgeted labor units for each activity.
Now, if I want to see and draw the S-Curve for particularly B group, budgeted units, Curve, what should I do in that Case??
Please let me know.
Thank you
Thank you for your comment,
I suggest you create two different activity codes and assign them to the activities. Then you can add slicers to the s-Curve and find the curve for each of the activities
@@GlobalProjectControl Thanks for the reply
But if suppose there are 10 activities in schedule and all 10 activities in the schedule has been assigned both labor A and labor B with some budgeted units.
And now I want to check only for Labor B, so
Can we assign Activity code as both of the labor A and B, to the activity
@@rupeshbhattacharya2903 Yes, you can assign the activity codes for different group types A & B, then when you use the filter, it will be updated the result