The recruiting lead needs a September review for HR leadership. Deliver saved active-candidate and open-position reports, a reusable position fill-days calculation, a September completed-fill report, its checked average and its Excel output. Candidates and vacancies must retain their own grain.
The recruiting lead needs a hiring review for HR leadership. Show active candidates with their positions, current vacancies, and the position fills completed during September. The reports must separate candidates who are still in the pipeline from rejected applicants and people already hired.
Build the candidate and position components at their own grains. A position can have several candidates, so candidate rows can't stand in for vacancy counts. Use a calculated field for each position's fill duration and keep its source dates beside it. Finish with the checked September average and an exported filled-position report. Your work carries across the project, including the saved pipeline and vacancy definitions, so the final deliverable preserves the supporting views rather than only a single metric.