Can I make a period over period pivot table with a dynamic date range?
I had a need to create a pivot table that has our % change ( this year sales - last year sales / last year sales). I was able to create an ETL that accomplishes this for any date this year. I am able to filter any date this year (MTD, QTD, YTD, etc.) and a beast mode will take the above formula to calculate my % change.
I am now having trouble taking this a step further. I now want to be able to look at any date, not just this year. For example if I want to look at Q4 2019, data from Q4 2018 is used for the formula. Is this possible? Thank you!
Here is a picture of my ETL: