Hi,
I have been asked to produce a table (a bit like an organisational hierarchy) which shows the ratio of supervisors to staff for every department in my organisation. We have a nominal (which is an excel s/s) which is refreshed on a monthly basis and shows every employee from the top down (approx. 3,500 rows). It contains, amongst other things, the employees department and their position within the organisation, which is a number between 1 & 9.
Joe Bloggs Marketing 1
Fred Smith Marketing 2
Sarah Jones Marketing 3
Steven Ross Sales 4
Is it possible from this to build a pivot table which shows the number of staff at each level which would enable me to calculate supervisor ratios, i have been asked to build something which can idealy be refreshed on a monthly basis alongside the nominal.
I just can't seem to get my head round were to even begin,
Unfortunately I am unable to upload an example of the s/s so hope that this all makes sense?
Thanks in Advance
Bookmarks