I am trying to SUM prior year data from a subquery (MATRIX). Basically…here’s what I tried but it produces the same data as the current data (incorrect).

I am trying to SUM prior year data from a subquery (MATRIX). Basically…here’s what I tried but it produces the same data as the current data (incorrect).

I am trying to SUM prior year data from a subquery (MATRIX). Basically…here’s what I tried but it produces the same data as the current data (incorrect).