increment rows starting from a month on month

[karthik-1237]

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.

[Qiu · Accepted solution]

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

And what is your desired output?

[karthik-1237]

Hi @ Qiu.

Current Month is the new Column which needs to be added. For every account id the first row/observation must start from Jan-18 and the increment should go on till last observation.

[grazitti_sapna · Accepted solution]

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

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

[Qiu]

@karthik-1237 
Thanks @grazitti_sapna for the inspriation.😁

[grazitti_sapna]

@Qiu  most welcome.

Thanks!

[binuacs · Accepted solution]

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