Find weekly report date from cumulative total

[BosKev]

Hi,

I have a combined list of employee with date. The list is cumulative;  At the end of month I have a 4 week cumulative total but the "Date" Field is being overwritten to the latest report date.

What I need is be able to overwrite the "date" field to reflect the accurate week of the employee's record for trending purpose. Is there a good solution using Alteryx? Thanks.

see below for example:

				Ideal Output
Employee ID	Movement Type	Date		Employee ID	Movement Type	Date
Bob	Hire	1/4/2019		Bob	Hire	1/4/2019
Sara	Loss	1/4/2019		Sara	Loss	1/4/2019
Frank	Hire	1/4/2019		Frank	Hire	1/4/2019
Bob	Hire	1/11/2019		Kevin	Hire	1/11/2019
Sara	Loss	1/11/2019		Dave	Loss	1/11/2019
Frank	Hire	1/11/2019		Amy	Loss	1/11/2019
Kevin	Hire	1/11/2019		Casey	Loss	1/18/2019
Dave	Loss	1/11/2019		Louis	Loss	1/18/2019
Amy	Loss	1/11/2019		Carl	Loss	1/18/2019
Bob	Hire	1/18/2019		Robert	Hire	1/25/2019
Sara	Loss	1/18/2019		Will	Hire	1/25/2019
Frank	Hire	1/18/2019		Denise	Hire	1/25/2019
Kevin	Hire	1/18/2019
Dave	Loss	1/18/2019
Amy	Loss	1/18/2019
Casey	Loss	1/18/2019
Louis	Loss	1/18/2019
Carl	Loss	1/18/2019
Bob	Hire	1/25/2019
Sara	Loss	1/25/2019
Frank	Hire	1/25/2019
Kevin	Hire	1/25/2019
Dave	Loss	1/25/2019
Amy	Loss	1/25/2019
Casey	Loss	1/25/2019
Louis	Loss	1/25/2019
Carl	Loss	1/25/2019
Robert	Hire	1/25/2019
Will	Hire	1/25/2019
Denise	Hire	1/25/2019

[JordyMicheal]

Hey @BosKev 

I think this is doing what you'd like.
A summarize tool grouping on the first 2 and the first on field 3.

let me know if I'm off 🙂

Thanks,
Jordan

[JosephSerpis · Accepted solution]

Hi @BosKev I mocked up this workflow which I think answers your question. Let me know what you think?