This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
After removing the results columns from your input, the WF transposes Years and Months to get the data into a long format. These are joined and unioned to give one row for each Contract and year. The first Multi-row tool calculates the number of months to be allocated from the previous year. The next one calculates the revenue for the current year taking into account any left over from the previous one. A crosstab and rename to get the results in the correct format
Finally, these are joined back to your original data.
In the calculation for the revenue, I prorated the amounts based on the number of months in the start year.