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.
