LEAVES

Retrieves all leaf-level values in a hierarchy as an array for use with aggregate functions.

The LEAVES identifier returns all the leaf node values as an array. It needs to be used with an aggregate function in a calculated row.

Example

Let's create a calculated row to store the minimum values of the leaf nodes under the "Channel Partners" product segment.

Using LEAVES identifier