Accumulated sum within each hierarchy group (as a measure)

Niels Thomsen

January 07, 2026 10:36

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

sum(0, 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 (measure).

Now the table looks like this: