It's easier to assist if you can provide a .twbx packaged workbook (File - Export as Packaged Workbook).
Are you showing just the months, or do you have a daily breakdown?
If months, you can simply group to the month level and show the sum. If today is 6/6/13, then the current month Jun-2013 will only have 6 members and thus will in effect be MTD.
If however, you have 6/1/13, 6/2/13 etc. in your view, you can achieve what you need with a table calculation. (WINDOW_SUM(SUM([MeasureField])).
The knowledge base has lots of useful information. Try starting here
Yes i need to show daily breakdown. The problem is i have values till last month only. That is may. So instead of current month is there any way to put last month in calculated field ?
I'm not sure I understand your question. I would think May MTD would include every day in May.
June is the only month where MTD would differ from the full day count in the month.
Since today is 6/6, are you asking how to force May to show only 5/1 to 5/6, so it can be compared to 6/1 to 6/6?
I'm afraid I still don't understand what you want.
Attached is your workbook showing the 2 methods I described in my previous post.
If that is not what you're after, you'll have to be more specific in your response.
MTDYTD.twbx.zip 116.6 KB