LEAVES

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.

LEAVES identifier