Accumulated sum within each hierarchy group (as a column)

Niels Thomsen

January 07, 2026 10:35

Type: Inserted as a column
Description: Calculates an accumulated sum of values from first row to each row, within each hierarchy group, in last column.
Range:
- Columns: Last column
- Rows: From first row to each row (siblings)
- Measures: First measure
Syntax:

sum(d-1, d1:0(s), m1)

Example

In the table above we want to accumulate the values within each year.

This is done by adding the Accumulated sum from the top within hierarchy level (column).

Now the table looks like this: