Hi I have an excel sheet that I use to track Manager development across my business.
Currently I have a Data entry sheet that has the below columns (There are ten phases so 1 to 10, plus the info before to allow me to filter)
Regional Manager - First Name - Last Name - Job Role - Location - Region - Country - Phase One - Phase Two - Phase Three......Phase Ten
Joe Bloggs Jim Smith AM Edinburgh North Scotland 4 1 0 3
Currently there are various elements for a manager to complete a phase
Phase 1 - 4
Phase 2 - 2
Phase 3 - 1
Phase 4 - 10
Phase 5 - 12
Phase 6 - 8
Phase 7 - 25
Phase 8 - 6
Phase 9 - 8
Phase 10 - 4
On the 2nd page (Percentage Completion page) I have a simple formula that calculates the % completion of each phase =SUM('CSA Data Entry'!G42/'CSA Data Entry'!$T$2) I have this inputted in the 10 phases across each row and directing to the relevant total for each phase.
$T$2 - Refers to a table of the above 10 phases - So when my Regional managers update to say one of their managers has completed 1 element
of phase 2 as an example it returns a 50% completion
What I would love is a 3rd sheet where using a pivot table or similar I could select the country or regional manager as an example and get an overview of the 10 phases for that country as a total and also an average of complete course completion.
I hope that makes sense - I am just starting out in the world of excel so thank you in advance to any help
Currently I have a Data entry sheet that has the below columns (There are ten phases so 1 to 10, plus the info before to allow me to filter)
Regional Manager - First Name - Last Name - Job Role - Location - Region - Country - Phase One - Phase Two - Phase Three......Phase Ten
Joe Bloggs Jim Smith AM Edinburgh North Scotland 4 1 0 3
Currently there are various elements for a manager to complete a phase
Phase 1 - 4
Phase 2 - 2
Phase 3 - 1
Phase 4 - 10
Phase 5 - 12
Phase 6 - 8
Phase 7 - 25
Phase 8 - 6
Phase 9 - 8
Phase 10 - 4
On the 2nd page (Percentage Completion page) I have a simple formula that calculates the % completion of each phase =SUM('CSA Data Entry'!G42/'CSA Data Entry'!$T$2) I have this inputted in the 10 phases across each row and directing to the relevant total for each phase.
$T$2 - Refers to a table of the above 10 phases - So when my Regional managers update to say one of their managers has completed 1 element
of phase 2 as an example it returns a 50% completion
What I would love is a 3rd sheet where using a pivot table or similar I could select the country or regional manager as an example and get an overview of the 10 phases for that country as a total and also an average of complete course completion.
I hope that makes sense - I am just starting out in the world of excel so thank you in advance to any help
