MEMBERS

The MEMBERS identifier returns all the immediate children's values as an array. It needs to be used with an aggregate function to return values.

Example

Let us consider the scenario where we have Manufacturer, Country, and Products in the row hierarchy. For a particular manufacturer, the minimum sales at a country level can be calculated using the formula as shown in the below image.

Using the MEMBERS identifier