The HR operations manager at Northstar Fieldworks needs an Excel roster for an assignment reconciliation. Include all workers, effective dates and related organization and manager values. Done means a reusable saved definition and a final exported output, without salary or hidden exception rows.
The HR operations manager needs a reusable worker roster for a reconciliation meeting. She needs both active and former workers, plus identifiers that let her trace organization and position assignments. Salary is outside this request and should stay out of the output.
Build the report in stages, preserving each prior decision. First establish worker grain and the full population, then add related values and dates. Give the output a predictable sort and export the final version. A blank manager is useful evidence during reconciliation, so don't remove the row simply to make the roster look tidy. At the end, the saved definition and exported output must describe the same report.