Hi,

I can't really think of another way other than this:

WITH Member [Measures].[Sales Last Day of Month] AS

(

[Date].[Calendar].CurrentMember.LastChild

,[Measures].[Sales Amount]

) ,FORMAT_STRING = "Currency"

SELECT

NON EMPTY

{

[Measures].[Sales Last Day of Month]

}

ON COLUMNS,

NON EMPTY

(

[Date].[Calendar].[Month]

)

ON ROWS

FROM [Adventure Works]