Calculate Previous Year Value in columns

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.

Example.xlsx

Accepted answers

Qiu

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

0329-Mahabirpanigrahi.yxmd

Tyro_abc

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

Previous Year Total.yxzp

All comments

Qiu

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

0329-Mahabirpanigrahi.yxmd

Tyro_abc

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

Previous Year Total.yxzp

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?

Example.xlsx

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

Previous Year Total (1).yxzp

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.

0329-Mahabirpanigrahi - r1.yxmd

Kamran1991

Hope attached solution will address you query.

Calculate Previous Year Value in columns.yxmd

Mahabirpanigrahi

HI @Kamran1991,

You solution is just giving me the previous record value. While I am looking for the previous Yr value for the combination on the file. Example attached.

Alteryx.png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703