Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Passing Previous month value to a new column

kiotsuresh
6 - Meteoroid

I have the Data like below,

 

DateSalesProfit
05/01/2022100300
04/01/2022200400

 

Date is is (MM/DD/YYY-Format).

 

I need the below Output:

DateSalesSalesPM(Prev month)ProfitProfitPM(Prev month)
05/01/2022100400(April month sales)

300

400 (April month Pft)
04/01/2022200      (March month Sales)400        (March month Pft)

 

Can somebody help me in achieving this?

3 REPLIES 3
AngelosPachis
16 - Nebula

Hi @kiotsuresh 

 

Welcome to the community. Please use the tags sparingly to get to the answer you are looking for faster. You will probably need to have a look at the multi-row formula tool. That will help you populate the profit and sales for a certain month from the row below (i.e. from the previous month).

 

Hope that helps,

Angelos

Emmanuel_G
12 - Quasar

Hi @kiotsuresh ,

 

Hope you're fine.

 

Please find a test below with exact desired output.

 

Let us know if it works the way you want.

 

Cheers !

 

Emmanuel_G_0-1657416517580.png

 

TonyaS
Alteryx
Alteryx

@kiotsuresh 

I see the AMP Engine tag used, but I do not see anything stating that this issue was specific to AMP Engine. Does anyone know if this was AMP specific? There are a lot of tags used on this post, but I try to follow anything with the AMP Engine tag. 

Tonya Smith
Sr. Technical Product Manager, Alteryx Engines
Labels