Please anybody help to write an MDX based on the following condition. I want to display [sales Qty] for the current year upto the current Month, with last two months data as weekly basis and the rest as monthly basis. (donot want to hardcode Year and month).

Hi Raheshc, Can you post the query you have written thus far? Cheers.Please mark correct answers :)

Hi raheshc, It is a little hard to write the MDX without any cube's information, this is the forum of Reporting Services, it will be better if you can post this question at Analysis Services forum at this link http://social.technet.microsoft.com/Forums/en-US/sqlanalysisservices/threads to get a specified support. Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.