Percentage within each hierarchy group (as a column)

Niels Thomsen

January 07, 2026 10:46

Type: Inserted as a column
Description: Calculates each row value as a percentage of the total of all row values within each hierarchy group.
Range:
- Columns: Last column
- Rows: Each row (siblings)
- Measures: First measure
Syntax:

sum(d-1, 0, m1) / sum(d-1, all(s), m1)

Example

In the table above we want to calculate the percentage on each level.

That means the Regions within a certain country on one level, and the countries within Europe on another level.

To do this we add the Percent in hierarchy level (column).

Now the table looks like this:

Notice the percentage is done on each level as described above.