[ROOT] dt DimEmployee < WHERE Status EQ NOTNULL > AGGREGATE Department ORDER BY _SUM DESC > TITLE Count of employees per department
17 items
| DepartmentId | _SUM |
|---|---|
| _SUM | 290 |
| Production | 179 |
| Sales | 18 |
| Purchasing | 12 |
| Information Services | 10 |
| Finance | 10 |
| Marketing | 9 |
| Facilities and Maintenance | 7 |
| Quality Assurance | 6 |
| Engineering | 6 |
| Shipping and Receiving | 6 |
| Production Control | 6 |
| Human Resources | 6 |
| Document Control | 5 |
| Tool Design | 4 |
| Research and Development | 4 |
| Executive | 2 |
Generated 2024-05-04 20:31:33.022 UTC