BeyondERP.Newsletter
Menu

Setup step on the Worker distribution statistics page · Human resources

Analyze the workforce by group

See how workers are spread across departments and age bands on a date.

Used by
Chief executive officer, Chief financial officer, Compensation and benefits manager and 7 more roles
Business process
Analyze HR programs
Menu item
HcmWorkerDistribution
Main table
CCTmpStatistics
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isAn inquiry page that shows how workers are distributed by criteria you choose, such as department and age.
What you do hereUse this page to group workers by selected criteria as of a date and see the counts per group.
ExampleFor example, BEAT groups by Department and Age with Age 10 as of 31 December 2026 and sees that the Warehouse department has 9 of its 20 workers in the 50-59 band.
Worker distribution statistics page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAnalyze HR programs
Menu pathHuman resources › Workers › Inquiries and reports › Worker distribution statistics
Set up firstEmployees Microsoft Learn
Used next byNumber of workers report Microsoft Learn
Related pagesSeniority list report Microsoft Learn
In this process Report headcount on a date · Plan service anniversaries
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Analyze the workforce by group

See how workers are spread across departments and age bands on a date.

Steps from Microsoft

  1. Go to Human resources > Workers > Inquiries and reports > Worker distribution statistics.
  2. In the Groupings field group, double-click Department, and then double-click Age.
  3. In the Age field, enter 5 to group results into five-year age bands.
  4. On the Setup tab, enter a date in the As of box.
  5. Select Update, and then review the results on the Totals tab.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
GroupingsThe criteria used to group workers.Microsoft Learn Department, Age
AgeThe size of each age band in years.Microsoft Learn 10
As ofThe date the distribution is calculated for.Microsoft Learn 31 December 2026
Current FTEThe number of workers in each group, shown on the Totals tab.Microsoft Learn 20

Common errors and fixes

MessageWhat to do
The Totals tab shows the previous resultThe distribution is calculated when Update is selected. Select Update after changing the groupings or the As of date. Microsoft Learn
Age bands are too wide or too narrowThe Age field sets the size of each band in years. Change it, for example to 5, and select Update. Microsoft Learn

Test checklist

  1. Double-click Department and Age in Groupings and enter 5 in Age.
  2. Enter today's date in As of and select Update.
  3. Check the Totals tab adds up to the number of workers.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Analyze the workforce by groupSet the As of date and the groupings first (for example Department, then Age with a band of 5 or 10 years), then select Update.The page calculates only when Update is selected, for the groupings and date entered.Which groupings does workforce analysis use?Reading the Totals tab after changing the date or groupings without selecting Update, so it still shows the previous calculation.Test: Distribution adds up

Feature management and licence

Licence or add-inHR, payroll and management roles read it to analyze the workforce. No Feature management feature is needed for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyCalculated, not stored as master data: the page fills a temporary statistics table (CCTmpStatistics) from the shared worker records each time it is updated. Checked in Dynamics 365
Can it be undoneNothing to undo: The page changes no data.
If you change it laterNothing downstream reads the result; it changes only when the As of date, the groupings or the worker records change and Update is selected again. Microsoft Learn
Technical architect

6Technical

Menu itemHcmWorkerDistribution Checked in Dynamics 365
FormHcmWorkerDistribution Checked in Dynamics 365
TableCCTmpStatisticsShown as “STATISTICS” in Record infoChecked in Dynamics 365
Who can open itPrivilegesView worker distribution statistics HcmWorkerDistributionViewDutiesInquire into jobs and positions HcmJobPositionInquireInquire into organizational process HcmOrganizationalProcessInquireInquire into workforce management process HcmWorkforceProcessInquireReview workforce management information HcmWorkforceReview
10 security rolesChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerCompensation and benefits manager HcmCompensationAndBenefitsManagerHuman resource assistant HcmHumanResourceAssistantHuman resource manager HcmHumanResourceManagerPayroll administrator HcmPayrollAdministratorPayroll manager HcmPayrollManagerRecruiter HcmRecruiterTraining manager HcmTrainingManagerAccounting manager LedgerAccountingManager
Checked in Dynamics 365
Roles to set it up and use itTo use itHuman resource manager HcmHumanResourceManagerHuman resource assistant HcmHumanResourceAssistantCompensation and benefits manager HcmCompensationAndBenefitsManagerRecruiter HcmRecruiterPayroll administrator HcmPayrollAdministratorGive people one of these roles. On this system, 10 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Update, InquiryChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=HcmWorkerDistribution
Data migrationLoad order: Worker distribution statistics has no data entity in Data management, so it can't be loaded from a file or a configuration template. It calculates from the worker records; load them with the Worker data migration template and calculate the distribution in each environment.Microsoft Learn
Everyone

8Sources

To cite this step: HR-RWIR-090, Analyze the workforce by group. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/HR-RWIR-090