How to make the workflow whose year-on-year difference and year-on-year ratio.

[SaoriYamguchi]

Hi, I'm using alteryx every day.

I want to know how to make the workflow whose year-on-year difference and year-on-year ratio.

Could you please tell me?

[fmvizcaino · Accepted solution]

Hi @SaoriYamguchi ,

For that, you can use a multi-row tool grouping by the month. You only need to keep in mind that you need to have data for all months for this solution to work.

Let me know if this makes sense to you

Best,

Fernando Vizcaino

[SaoriYamguchi]

Thank you！

I appreciate your solution.