Need a MDX query that returns list of months from start of year up to specified month.

Answer 1

SELECT YTD([Date].[Calendar].[Month].&[2003]&[8])ON 0FROM [Sales Summary];