Passing Previous month value to a new column

[kiotsuresh]

I have the Data like below,

Date	Sales	Profit
05/01/2022	100	300
04/01/2022	200	400

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

I need the below Output:

Date	Sales	SalesPM(Prev month)	Profit	ProfitPM(Prev month)
05/01/2022	100	400(April month sales)	300	400 (April month Pft)
04/01/2022	200	(March month Sales)	400	(March month Pft)

Can somebody help me in achieving this?

[AngelosPachis]

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]

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 !

[TonyaS]

@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.