Dynamic Quarterly YoY comparison

[pokhan27]

Hi Expert

I have trying to have dynamic Quarterly YoY comparison . scenario is given below

for example: 

id	region	20-Feb	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-20
1	xyz	11000	15000	15000	23000	12000	9000	11000	15000	11000	12000	13000	14000

in above case i am doing qtd comparison. if i am in may 2021 and doing Quarterly YoY comparison i want to have the value as "Q1-2020+Q2-2020+May2020" i don't want entire q3 data. similarly i want to make this comparison dynamically like on june it will be "Q1-2020+Q2-2020+May2020+June2020" and in july it will be "Q1-2020+Q2-2020+Q3-2020"  and so on. can we do that in alteryx. 

[pokhan27]

Thank you for your response, and am able to get what i desired for,