Replicating steps from excel to alteryx

[terrellchong]

Hi,

I have a set of data and pivoted table that I would like to do it thru alteryx. But I have a hard time figuring out the logic.

As my pivoted data is according to financial year, it starts from 2008_9, which is Sept each year.

The pivot table part was easy, but the table under the pivot table is the part where i got stuck.

For example, the number previously was manually plug it into the selected cell. I was thinking about the logic, which human can see that the logic is rather simple, but its hard to convert the logic to alteryx.

[Alayna]

Hi, I saw no one answered so I decided to take a shot at it. I think I understand your ask, basically taking every number from your pivot in order and putting it in that table. What do you think of the attached?