Hi all!
The attached spreadsheets lists employees with various employee information, including management level and employee type. A snippet of it is below:
| Global Line of Service | Work Location - City | Management Level | Employee Type |
| Assurance | London | Manager | Regular |
| Advisory | London | Manager | Regular |
| Advisory | London | Director | Regular |
| Tax | London | Partner | Partner |
| Advisory | London | Senior Manager | Regular |
| Advisory | London | Senior Manager | Regular |
| Tax | London | Manager | Regular |
| Tax | London | Manager | Regular |
The idea is to generate a matrix style table with the unique management levels in one dimension and unique employee types in the other. The values would then be counts of the number of instances that satisfy both dimensions within the data set, looking like the following:
| | Manager | Director | Partner | Senior Manager | Senior Associate | Associate | Administrative | Intern/Trainee | Specialist |
| Regular | 1 | 9 | 0 | 8 | 10 | 6 | 3 | 2 | 0 |
| Partner | 0 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 |
| Fixed Term | 6 | 3 | 1 | 12 | 16 | 8 | 4 | 5 | 1 |
* Dummy data so won't be the real values
The ultimate goal would be to keep the other data (location, line of service etc) within the data set (somehow) as I'd like to be able to drill into the numbers to see the split by location/LoS etc.
Any help would be massively appreciated!
