Aggregate Column Totals for Period-over-Period Result

If I have a period-over-period (%) column, how can I dynamically sum the input columns in Metabase to get a period-over-period growth figure from the total, instead of the default in Metabase which is to sum all of the percent values.

For example, if you look at the sample screenshot below...

Metabase is currently adding up the values in the column "Year-over-Year Change (%)", and giving me 1800%.

However, I'd like to have Metabase do the total aggregation on the input columns first (Revenue) and then produce the legitimate year-over-year change result (i.e. Rows 19-21).

hi, you're looking for Sliding windows in MBQL · Issue #9393 · metabase/metabase · GitHub, which Metabase does not support yet