[ROOT] dt DimEmployee < WHERE Status EQ ALL AGGREGATE Department ORDER BY _SUM DESC > TITLE Count of employees per department
17 items
| DepartmentId | _SUM |
|---|---|
| _SUM | 296 |
| Production | 179 |
| Sales | 18 |
| Purchasing | 14 |
| Marketing | 10 |
| Finance | 10 |
| Information Services | 10 |
| Facilities and Maintenance | 7 |
| Production Control | 7 |
| Shipping and Receiving | 6 |
| Engineering | 6 |
| Quality Assurance | 6 |
| Human Resources | 6 |
| Tool Design | 5 |
| Document Control | 5 |
| Research and Development | 4 |
| Executive | 3 |
Generated 2024-05-18 11:37:33.467 UTC