KellyDuehring
New Member
I need to create a cascading dashboard for project progress. What I am struggling with is the calculation for the parent child relationship.
In the attached workbook, I need to create a dashboard to show overall progress (not in Gantt) of each deliverable, how that relates to percentage complete of the Project and then ultimately the progress as a whole.
I have an example of what I want to see on sheet 2. I have to add thermo to this also to show where on a scale of 100% the completion for each project and each deliverable is. Pretty sure I can master this part, but needing some help on the calculation without having to create every one.
Thanks
In the attached workbook, I need to create a dashboard to show overall progress (not in Gantt) of each deliverable, how that relates to percentage complete of the Project and then ultimately the progress as a whole.
I have an example of what I want to see on sheet 2. I have to add thermo to this also to show where on a scale of 100% the completion for each project and each deliverable is. Pretty sure I can master this part, but needing some help on the calculation without having to create every one.
Thanks