increment rows starting from a month on month

Question

Hi All,

Need to create an alteryx workflow for the below result. How to obtain the below result

Current Month is the column which is to be calculated. We need to get the increment every month starting from Jan-18 for every account id.

Every Account First row/ Record will start from JAN-18, and Second Row will be Feb-18 an so on. We need to increment from Jan-18 till last observation is there for that account id.

Above shown is for a sample account and the same has to be applied for multiple account id.

month on month.PNG

Qiu · Accepted Answer

@karthik-1237 
The snapshot your provide is your input?

And what is your desired output?

grazitti_sapna · Accepted Answer

Hi @karthik-1237, give this a try. I hope this helps!

Please mark my post as a solution and like it if it works.

binu_acs · Accepted Answer

@karthik-1237 Another way of doing this with the help of multi-row formula tool