Newbie question so please bear with me!
As previously discussed, we use 3 columns to calculate the % Complete (which we then have to manually enter into the standard '% Complete' column), which are:
- Planned Effort
- Actual Effort
- Remaining Effort
What I need to be able to do is to create a Summary Report based on the three above fields and % Complete for all Projects - all of these values are in the first row of each Sheet.
Using a Summary Report or Row Report, it does not seem possible to do this. I have looked at the Sheet Summary tab for each Project but I cannot see how I can select these fields on Row 1.
Ideally, I would like to see:
I would be grateful, if someone could let me know?
- Is it possible to do this; and
- If it is, how I can do it
Thanks in advance for your help.