'Variance to ticket home value' question

Hello,

So we began a dynamic pricing strategy in November 2021. 

I have created some dashboards within analytics to track additional revenue thanks to dynamic pricing by looking at the 'variance to ticket home value' dimension and then used an 'order date' filter to only consider orders placed from when we started dynamically pricing (1st Nov 2021). This appears to be working fine apart from one production...

The production in question was moved from the summer of 2021 to christmas 2022 due to COVID. When we moved the production (before we started the dynamic pricing strategy) we also raised prices as it was moving into our Christmas slot. So now when I look at the 'variance to ticket home value' figures for the show, they include not only the dynamic pricing changes since Nov 1 2021, but also the price increases from the show move prior to that. So I can't accurately tell how much of the additional revenue is just down to our dynamic pricing strategy.

Is there anyway of getting analytics to consider the prices on 31/10/21 as base/home prices for this show? Then any price increases after that were down to our dynamic pricing strategy and i'll have the figure I need.

Any help much appreciated!

Cheers