# Minimum Subset

Contents[Hide]

The Minimum Subset function returns the smallest value(s) in an input data series.

When used in a formula visualization, you can specify a count of more than one, e.g, to return the 3 smallest values.

## 1. Syntax

```BOTTOM(d0,s0,Alignment)
```

## 2. Input

The Minimum Subset function requires the following input:

• d0 - Input data values - The set of data values for which the Minimum Subset is calculated.

## 3. Parameters

The Minimum Subset function can be given the following parameters:

• s0 - Minimum Subset Count (Optional) - The number of values to be returned by the formula. Default value is 1.
• Alignment (Optional) – Hierarchy placeholder to be used as the alignment axis. If an alignment hierarchy is not indicated, the subset is applied to the whole result.

When you use the BOTTOM function within a metric set, it can only return a single value (s0 must be 1). In order to return the bottom 3 values, for example, you must use a formula visualization. This applies to the other subset functions as well.

## 4. Output

The Minimum Subset function generates the following output:

• Minimum Subset - The Minimum Subset result set.