Alteryx tagging help

[datausernyc0419]

Thank you in advance for the help! 

I have the attached dataset tagged by the following 4 attributes:

• Account ID = unique customer
• Month = month / year of customer data
• ARR = company ARR
• Time period = # of months since first joining (i.e., 0 = first month, 1 = 1 second month, etc.)

I am trying to do the following 2 tags in Alteryx, but have spent a few hours and have failed. Any workflow examples would be super great:

1. I am trying to do a calc where for each Account ID, you divide their max time period by their Time Period = 1. For example, if an AccountID has 16 as their highest Time Period, the calculation would be their ARR for Time Period 16 divided by Time Period =1
2. I am trying to calculate year over year growth rate for each account, so I want to add in the following tags based on the following calcs (but not all account IDs will have all of these figures since some accounts are only present for a few months
1. Year 1 growth = ARR for Time Period 13 divided by Time Period 1
2. Year 2 growth = ARR for Time Period 25 divided by Time Period 13
3. Year 3 growth = ARR for Time Period 37 divided by Time Period 25
4. Year 4 growth = ARR for Time Period 49 divided by Time Period 37
5. Year 5 growth = ARR for Time Period 61 divided by Time Period 49
6. Year 6 growth = ARR for Time Period 73 divided by Time Period 61
7. Year 7 growth = ARR for Time Period 85 divided by Time Period 73
8. Year 8 growth = ARR for Time Period 97 divided by Time Period 85
9. Year 9 growth = ARR for Time Period 109 divided by Time Period 97

Workflow suggesting to get these done would be super appreciated -- thank you in advance!

[CoG]

Here you are!

[datausernyc0419]

Thank you so much for the help here! 

I just ran this, but one question on the following years tag. I don't think it is dividing the right time periods currently. For example, Year 2 should be Time Period 25 divided by Time Period 13, but I think currently it is ending up taking Time Period 29 divided by Time Period 13 (similarly occurs for the following years). Any thoughts? 

1. Year 1 growth = ARR for Time Period 13 divided by Time Period 1
2. Year 2 growth = ARR for Time Period 25 divided by Time Period 13
3. Year 3 growth = ARR for Time Period 37 divided by Time Period 25
4. Year 4 growth = ARR for Time Period 49 divided by Time Period 37
5. Year 5 growth = ARR for Time Period 61 divided by Time Period 49
6. Year 6 growth = ARR for Time Period 73 divided by Time Period 61
7. Year 7 growth = ARR for Time Period 85 divided by Time Period 73
8. Year 8 growth = ARR for Time Period 97 divided by Time Period 85
9. Year 9 growth = ARR for Time Period 109 divided by Time Period 97

[CoG]

This is what the workflow is generating on my end, is this incorrect?