Plzz tell me how to implement the MTD For the whole year upto any date of the selected month?
i.e if i select a date of September then the MTD till that date of sep with that date of previous month from the starting of the year.
Create a Day field in the script from your Date field:
Load ...your fields...,
Day(MyDate) as Day
You can then use that Day field in set analysis expressions:
View solution in original post
Please find the Attcahment . Different ways for achieving YTD and MTD are mentioned in this . Hope this will help you .