Job Name Role M1 M2 M3 X Bob Mngr 15 15 15 X Sue Sup. 10 10 10 X Jon Anlst 20 20 20 Y Sue Sup. 10 10 10 Y Rick Anlst 20 20 20 Y Bob Mngr 5 5 5 X Jim Mngr 20 20 0 Y Phil Sup. 0 0 20
This data set represents how employees times are allocated to certain projects (X and Y) through the given months (M1, M2, M3). I have their name and their level (Manager, Supervisor, Analyst). What I would like to achieve is a summary of how many managers, supervisors and analyst are being utilized in a given month in total, regardless of the project they are working on.
The following table would be the results I am looking for.
M1 M2 M3 Mngr 2 2 1 Sup. 1 1 2 Anlst 2 2 2
I have attempted to utilize a pivot table but am unable to recreate the desired results. What is throwing me for a loop is that Sue appears in two lines, so when I try to count managers, it is double counting her.
Any help is greatly appreciated.