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!

[TheOC]

hi @prernaaher 

Are you able to provide a sample input and a desired output so that i can look at this for you?

Cheers,
TheOC

[Qiu]

@prernaaher 
need data😁

[prernaaher]

@TheOC Please find sample data attached.

[prernaaher]

@Qiu Attached sample data and desired output.

[Qiu]

@prernaaher 
I hope I understand you correctly and the calculating year quarter part is interesting for me.

[prernaaher]

Thank you @Qiu Can this be dynamic according to the user input? I am not sure if I have to move it by 2 quarters I might have to repeat the process.

[Qiu · Accepted solution]

@prernaaher 
Oh, sorry about that.
Made a little modification and now it is dynamic to take user input.

[prernaaher]

@Qiu Genius! This is too good. Thank you :)

[prernaaher]

@Qiu One more question - Can we move quarter for individual product?