[ROOT]  dt  DimEmployee  <  WHERE Status EQ ALL   AGGREGATE Department   ORDER BY _SUM DESC  >   TITLE Count of employees per department   

Count of employees per department

17 items

DepartmentId_SUM
_SUM296
Production179
Sales18
Purchasing14
Finance10
Information Services10
Marketing10
Facilities and Maintenance7
Production Control7
Quality Assurance6
Human Resources6
Shipping and Receiving6
Engineering6
Document Control5
Tool Design5
Research and Development4
Executive3

Generated 2025-07-29 18:27:15.510 UTC