[O] Relative Remote Reference (column->row)

[Volker Strobel]

Hi there,

I'm trying to refer to the row number of a remote table, using the current column number shifted by one. 

Remote Table:
#+NAME: my-table
| Header1 | Header2 |
|---------+---------|
|   a     |    23  |
|   b     |    7    |
|   c     |    13  |
|   d     |    66  |
|   e     |    5    |
|---------+---------|
| Result  |  42 |

Table where remote value should be inserted:
...

#+TBLFM: @address@hidden remote(my-table,@$#$2)

My problem is, that this remote reference starts in row 3 (because of @$#), however, I'd like to start in row 2 (that means @$#-1). However, this relative reference does not seem to work here.

Any idea what command I can use here?

Thanks!

Best, Volker