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:

Best Answers


  • GrantSmith
    GrantSmith Coach
    edited January 2022

    Looks like @MarkSnodgrass is a faster typer than me. Gotta work on my stealthy quickness.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Thank you so much, I will check out the links.

  • Just an update: everything seems to be working great. Thank you again!