Contents

1 MDX

WITH MEMBER [InternetUnitPrice] AS
'
	SUM(
		IIF
		(
			IsLeaf([Date].[Calendar Date].CurrentMember)
		,	[Date].[Calendar Date].CurrentMember
		,	[Date].[Calendar Date].CurrentMember.LastChild
		)
	,	[Measures].[Internet Sales-Unit Price]
	)
'
SELECT
	{
		[InternetUnitPrice]
	,	[Measures].[Internet Sales-Unit Price]
	} ON 0
,	{
		[Date].[Calendar Date].Members
	} on 1
FROM [Analysis Services Tutorial]