Calculate Previous Year Value in columns

[Mahabirpanigrahi]

HI Alteryx Experts, Need your help in calculating Previous Year Value in the column to the table. Have attached the data here, where i have shown my desired output in yellow color. I have tried a long process, thought checking with community for a better/easiest way to build this Appreciate in advance for help. Thanks Mahabir.

[Qiu · Accepted solution]

@Mahabirpanigrahi 
We maybe can use the Multi-Row tool here.

[Tyro_abc · Accepted solution]

Hi @Mahabirpanigrahi 

The attached workflow would give you the previous year's value. 

Step1: Sort by Market, Product, SKU, and Period

Step 2: Use Multi-Row Formula Tool to read the Previous year value for the same combination ( mentioned in Group By Clause) 

Step 3: Same as Step 2 but for another measure.  

Happy to help, 

Regards

Arundhuti

[Mahabirpanigrahi]

HI @Tyro_abc  & @Qiu  - Appreciate your help! 

It worked on the file that was shared, but when I add more months to the file. both the model doesn't work?

Can you please check and advise?

[Tyro_abc]

That solution was based on the data you provided. If you have more than one row for a particular Market, Product, SKU, Year combination, you can simply add them and then use the multi-row tool. Accordingly, we need to adjust the formula

Regards

Arundhuti

[Qiu]

@Mahabirpanigrahi 
Previously It is only considering the Year, ignoring the Month.
now I thin you are saying that the same month of last year.

[Mahabirpanigrahi]

thank you! Seems the file you attached is the old file. Request to share the revised on.

[Tyro_abc]

sorry about that, here you go. Use the second excel you attached with this workflow.

Regards

Arundhuti

[Mahabirpanigrahi]

Hi @Tyro_abc 

Seems there is confusion. I wanted to PY data by each month. 

Attached is the image of what I expect to be the outcome. 

Request to have a look. 

Thanks

Mahabir

[Kamran1991]

Hope attached solution will address you query.