Week on Week Movements

[RaghavanR]

Hi,

I have a situation that I have data by weekend (weekend is on Friday) and it is a cumulative one for the month and want to arrive at Week on week  movements.

Can some one please guide me on how to get this done in Alteryx?

Sample data is as below:

Date	Identifier	Amount	WoW Movement
4/12/2020	A/cts Closed	100	100
11/12/2020	A/cts Closed	180	80
18/12/2020	A/cts Closed	200	20
24/12/2020	A/cts Closed	250	50
31/12/2020	A/cts Closed	300	50
08/01/2021	A/cts Closed	10	10
15/01/2021	A/cts Closed	110	100
22/01/2021	A/cts Closed	180	70
29/01/2021	A/cts Closed	200	20

[clmc9601 · Accepted solution]

Hi @RaghavanR,

Do you mean you want to calculate the numbers in the WoW column that you provided? If so, does this accomplish your goal?

 I hope it helps!

[Emil_Kos · Accepted solution]

Hi @RaghavanR,

Not sure if this is what you wanted:

Output:

[RaghavanR]

Thanks @Emil_Kos  and @clmc9601 for your quick help. 

I can say both of your solutions are working for me and I have adapted them in my bigger workflows.

Thanks a lot for your help and guidance.