Hi all, I'm new to MDX,
I want to create a query to get on Rows every end of each month.

The basic query on AW gets all days,

Code:
SELECT
NON EMPTY { [Measures].[Sales Amount] } ON COLUMNS,
NON EMPTY { [Date].[Calendar].[Date]  } ON ROWS
FROM [Adventure Works]
But I want to get only month's ends:


.................... Sales Amount
July 31, 2005....... 15,012.18 $
August 31, 2005..... 20,859.78 $
September 30, 2005.. 35,782.70 $
October 31, 2005.... 6,749.98 $
November 30, 2005... 18,590.45 $
December 31, 2005... 22,168.72 $


Thanks in advance
Tito