Returns the minimum of values found in the tuples of a set.
Min ( set [,numeric_value_expression ] )
| set | The set to search for values. |
| numeric_value_expression | Optional numeric value expression. |
The return value of Min is #MISSING if either of the following is true:
For every quarter, the following query displays the minimum monthly sales value.
WITH MEMBER
[Measures].[Minimum Sales in Quarter]
AS
'Min ([Year].CurrentMember.Children, [Measures].[Sales])'
SELECT
{[Measures].[Minimum Sales in Quarter]}
ON COLUMNS,
[Year].Children
ON ROWS
FROM Sample.Basic
This query returns the grid:
| Minimum Sales in Quarter | |
|---|---|
| Qtr1 | 31538 |
| Qtr2 | 32917 |
| Qtr3 | 33073 |
| Qtr4 | 31971 |
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |