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.
Comments
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.