So you could for example (if you wanted to calculate growth over prior year) do some kind of "Case when transaction date is this year, then {field} when transaction date is last year then negative {field} else 0 end"