Rolling Months data

Hi, I have the data for months in the format beginning from Jan20 to Jun21. Every month I need to show 12 months of data on rolling basis. For eg. in May'21 I need to show the data from Jul20 to May21. In Jul21, it will be Aug20 to Jun21 and so on. Is there any way to automate this in Alteryx? Thanks. Regards DNS

Date Time

Accepted answers

All comments

atcodedog05

Hi @DNS_007

Here is how you can do it.

Workflow:

1. Calculating the current month.

2. Date diff between dates and current month to get months btw. Keeping dates where diff is <=12 months rolling prev 12 months.

Hope this helps : )

months.yxmd

DNS_007

Hi, Thanks for the response. However I have data in form of Months directly. As mentioned, Jan21, Feb21 and so on, and everytime when i do sum using Summation tool I have to manually go and uncheck the month and add current month. Thanks.