Developing a simple dashboard - % Trained and Projects Completed

[damonreid]

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.