Returns a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by the Year level in the Time dimension.
Ytd( [ Member_Expression ] )
A valid Multidimensional Expressions (MDX) expression that returns a member.
If a member expression is not specified, the default is the current member of the dimension of type Time (Time.CurrentMember).
The Ytd function is a shortcut function for the PeriodsToDate function where the level is set Year. That is,
Ytd(Member_Expression) is equivalent to
The following example returns the sum of the
Measures.[Order Quantity] member, aggregated over the first eight months of calendar year 2003 that are contained in the
Date dimension, from the Adventure Works cube.
WITH MEMBER [Date].[Calendar].[First8MonthsCY2003] AS Aggregate( YTD([Date].[Calendar].[Month].[August 2003]) ) SELECT [Date].[Calendar].[First8MonthsCY2003] ON COLUMNS, [Product].[Category].Children ON ROWS FROM [Adventure Works] WHERE [Measures].[Order Quantity]
Help and Information
17 July 2006