Max function

[PCS_Mazintl]

I have read (and re-read) the series of articles about the MAX function, and I almost have it working. But the following gives me a total across the 3 countries, rather than the maximum of any of the 3. What am I doing wrong?

WITH MEMBER
[customer].[country].[High Sales] AS
'Max([customer].[Country].members ,
[unit sales] )'
SELECT
{ ([unit sales],[customer].[Country].children ) ,
([unit sales],[customer].[country].[High Sales]) }
on columns ,
non empty [Product].[Product family].children ON rows
FROM [warehouse and sales]

It must be in my numeric expression, the 2nd argument of the MAX function.

[PCS_Mazintl]

OK got it now ...

WITH MEMBER
[customer].[country].[High Sales] AS
'Max([customer].[Country].[country].members ,
measures.[unit sales] )'
SELECT
{ ([unit sales],[customer].[Country].children )
,([unit sales],[customer].[country].[High Sales]) }
on columns ,
non empty [Product].[Product family].children ON rows
FROM [warehouse and sales]

I needed [country] twice in the set of the MAX function, but only members, not children. But I wanted children in the columns, because I did not want the ALL.

[Island1]

Easy enough to miss if you started on AS2k or earlier ...

But thanks a lot for posting your solution. It may benefit others having similar woes ...

Good Luck.

Bill