The Last YTD is fine as per the code :
The Last YTD is fine as per the code :
===========================================
WITH MEMBER [Measures].[Current YTD] AS
SUM({[Date].[Calendar].[Date].[January 1, 2004]:[Date].[Calendar].[Date].[March 22, 2004]}
, [Measures].[Internet Order Quantity])
MEMBER [Measures].[Last YTD] AS
SUM( {[Date].[Calendar].[Date].[January 1, 2003]:[Date].[Calendar].[Date].[March 22, 2003]} -- Jan 1, 2003: March 22, 2003
, [Measures].[Internet Order Quantity]
)
SELECT {[Measures].[Current YTD]
, [Measures].[Last YTD]
} ON 0
FROM [Adventure Works]
=================================
NOTE : This mean Last YTD is here as true, now my question is if we wish to retrieve data for Last YTD as false then how we can do it.
I mean, looking data all except Last YTD.
Please help me do it and provide the mdx.
Thanks in advance.