1 of 1 people found this helpful
I would do the year as a quick filter, and then the month as a parameter. Then create a calculation that looks like this:
[Month] <= [Month Parameter]
and put it on the filter shelf and set it to "True".
If this resolves your issue, please mark your question as answered.
This is impossible to do because if we are applying filter on both year and month tho whole sheet gone through the filter.that means we can get get only that particular month data i.e underlying data only.But we can do it by using parameters and it is called as YTD not MTD .
It's working but i have one doubt we can do it by putting both year & Month fields in filter to calculate MTD. I think it's impossible but is there anyway to do it.If you have a way to do it just mail it to me email@example.com