Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  MDX Query: Every end of each month on rows

Author  Topic  TitoPeru Starting Member 1 Post Posted - 2011-09-29 : 20:22:03 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, 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