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


  • Does this solution also work on columns added as single coulmn?

    sum(c1:c-1, 0, m1) 

  • Hi Belinda,

    You can do sum(c1:c3, 0, m1), but you cannot do sum(c1:c-1, 0, m1).

    References to calculated columns only accepts "counting from left to right" with incremental c-numbers.

    BR / Ole


Please sign in to leave a comment.