Move Data by column/row depending on input

[prernaaher]

Hello,

I have FTE data for each quarter year i.e. 2021-Q1. I want move it by quarter to understand the impact by 1Q delay - depending on the input of the user on tableau interface. Eg: If the user chooses 'Delay' the FTE data should move by a quarter in Alteryx. i.e. the data from 2021-Q1 moves automatically to 2021-Q2 and so on.

Any help would be appreciated. I have been struggling with this for the longest time now :(

Thank you!

[Qiu]

@prernaaher 
Glad to help and thank you for the accept mark. 😁

[Qiu · Accepted solution]

@prernaaher 
Since you asked very politely. 😁

[prernaaher]

@Qiu You are simply brilliant! Thanks a ton :)