Hi,
For some reason my brain is not working today.
I have two tables; one is a list of employee’s, where they work, their training status and certification status. The second table is a list of projects completed and by who (linked to the first table).
I want to be able to do two very simple things but can’t get it to work.
Firstly I would like to have the number and % of each trained and certified for each of the 13 areas they work in.
e.g. if you have 10 people working in a department and 3 of them are trained at level 1, 3 at level 2 and the rest have received no training it would look like this
Person 1 Trained1
Person 2 Trained2
Person 3 None
…
Person 10 Trained 1
But I want to be able to say
Department A
Trained 1 3 30%
Trained 2 3 30%
Trained 3 0 0%
None 4 40%
Secondly I would like to say how many projects per person working in that area have been completed per month in 2010.
E.g., if department A above had completed 7 projects in January and department b had only completed 1, but had 100 employee’s it would look like this
January
Department A 0.70 Projects per Person Trained
Department B 0.01 Projects per Person Trained
Year to Date
Department A 0.70 Projects per Person Trained
Department B 0.01 Projects per Person Trained
Again I know this is simple but any help is greatly appreciated.
Damon.
For some reason my brain is not working today.
I have two tables; one is a list of employee’s, where they work, their training status and certification status. The second table is a list of projects completed and by who (linked to the first table).
I want to be able to do two very simple things but can’t get it to work.
Firstly I would like to have the number and % of each trained and certified for each of the 13 areas they work in.
e.g. if you have 10 people working in a department and 3 of them are trained at level 1, 3 at level 2 and the rest have received no training it would look like this
Person 1 Trained1
Person 2 Trained2
Person 3 None
…
Person 10 Trained 1
But I want to be able to say
Department A
Trained 1 3 30%
Trained 2 3 30%
Trained 3 0 0%
None 4 40%
Secondly I would like to say how many projects per person working in that area have been completed per month in 2010.
E.g., if department A above had completed 7 projects in January and department b had only completed 1, but had 100 employee’s it would look like this
January
Department A 0.70 Projects per Person Trained
Department B 0.01 Projects per Person Trained
Year to Date
Department A 0.70 Projects per Person Trained
Department B 0.01 Projects per Person Trained
Again I know this is simple but any help is greatly appreciated.
Damon.