[ROOT]  dt  DimEmployee  WHERE Status EQ 'Current'  >   AGGREGATE Department   

17 items

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

Generated 2025-12-08 05:00:37.553 UTC