MDX Query: Every end of each month on rows

[GDub]

How about:

WITH MEMBER [Measures].[LastDayOfMonth] AS
[Date].[Calendar].currentMember.Lastchild.Name
SELECT NON EMPTY { [Measures].[LastDayOfMonth]
, [Measures].[Sales Amount]}
ON COLUMNS
, NON EMPTY { ([Date].[Calendar].[Month].ALLMEMBERS ) }
ON ROWS
FROM [Adventure Works]