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

Count of employees per department

17 items

DepartmentId_SUM
_SUM290
Production179
Sales18
Purchasing12
Finance10
Information Services10
Marketing9
Facilities and Maintenance7
Engineering6
Quality Assurance6
Production Control6
Human Resources6
Shipping and Receiving6
Document Control5
Research and Development4
Tool Design4
Executive2

Generated 2022-10-07 09:42:53.944 UTC