I have the data in the following form YearMonthMetricValues2020JanNet sales6%2021JanNet Credit Margin10% 2020FebNet Charge offs13%2021FebDelinquency ratio15% I need to calculate the percentage difference between net sales 2021(Jan) and net sales 2020 (Jan) I am new to Alteryx it would be really helpful if you could guide me Regards Priyanka

Year on Year calculation

Priyanka1996

I have the data in the following form

Year	Month	Metric	Values
2020	Jan	Net sales	6%
2021	Jan	Net Credit Margin	10%
2020	Feb	Net Charge offs	13%
2021	Feb	Delinquency ratio	15%

I need to calculate the percentage difference between net sales 2021(Jan) and net sales 2020 (Jan)
I am new to Alteryx it would be really helpful if you could guide me

Regards

Priyanka

Best Practices

Accepted answers

shreyanshrathod

Hi @Priyanka1996 ,

Hope this helps. You can build on it as per your exact requirement.

Regards,

Shreyansh Rathod

Year on Year calculation.yxzp

All comments

shreyanshrathod

Hi @Priyanka1996 ,

It would make it easy to guide you if you can attach relevant screenshot or an excel file with dummy input and output requirements.

I am not able to figure out your query from the attached screenshot.

Priyanka1996

Hi
I have attached the excel file
In the output tab, I have mentioned the calculation that I wish to create

yoy.xlsx

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335