I'm trying to set up a monthly budget in org mode, and carry over the balance for each category from month to month. So I'll have something like
|Category|Last |Budget|Actual|Balance| | |Month| | | | |--------+-----+------+------+-------+ |One |5 | 25| 10| 20|
Where Balance is LastMonth+Budget-Actual, and LastMonth is Balance for Category from the previous table.
I know I can use remote references and have one per category, doing something like @2$2=remote(previous_table,@2$5), and just repeat it over and over for each category, but it seems wasteful and awkward, when I feel like I should be able to use $2=remote(previous_table,$5) to solve the entire problem, but that syntax seems to simply copy over the value in the current table, without using the remote at all.
Is there some way to do what want more effectively?