# 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://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FMtpWmlyXer8i0ucqbOd6%2FFormula%20members%202.png?alt=media&#x26;token=ad3ac9b6-3f2d-4673-8571-25d5546b7df3" alt=""><figcaption><p>Using the MEMBERS identifier</p></figcaption></figure>