Returns the maximum of values found in the tuples of a set.
Max ( set [,numeric_value_expression ] )
| set | The set to search for values. |
| numeric_value_expression | Optional numeric value expression. |
The return value of Max is #MISSING if either of the following is true:
WITH
MEMBER [Measures].[Max Qtr2 Sales] AS
'Max (
{[Year].[Qtr2]},
[Measures].[Sales]
)'
SELECT
{ [Measures].[Max Qtr2 Sales] } on columns,
{ [Product].children } on rows
FROM Sample.Basic
| Max Qtr2 Sales | |
|---|---|
| Colas | 27187 |
| Root Beer | 27401 |
| Cream Soda | 25736 |
| Fruit Soda | 21355 |
| Diet Drinks | 26787 |
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |