# 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. 

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/53coxJJJr11J59fEMr81/Formula%20members%202.png" alt=""><figcaption><p>Using the MEMBERS identifier</p></figcaption></figure>