[ROOT] dt DimEmployee WHERE Status EQ 'Current' > AGGREGATE Department ORDER BY _SUM DESC >
17 items
DepartmentId | _SUM |
---|---|
_SUM | 290 |
Production | 179 |
Sales | 18 |
Purchasing | 12 |
Finance | 10 |
Information Services | 10 |
Marketing | 9 |
Facilities and Maintenance | 7 |
Human Resources | 6 |
Production Control | 6 |
Shipping and Receiving | 6 |
Quality Assurance | 6 |
Engineering | 6 |
Document Control | 5 |
Tool Design | 4 |
Research and Development | 4 |
Executive | 2 |
Generated 2024-09-08 02:22:14.006 UTC