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 |