Reference ranges

  • E.g. d1:d-3 or m1:m3 – use two references separated by a colon to define a range of columns, rows or measures.
  • Reference ranges can of course also be relative, e.g. -2:0 meaning a range starting 2 columns/rows back and up to the current column/row
  • A “classical” reference range could be an accumulation: d1:0 meaning from the first column/row to the current – or reverse d-1:0 meaning from the last column/row to the current.
Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.