Dear avinesh,
One of the options is to create a new calculated field that results in YTD. You can use this new value for reporting.
Example YTD:
The New calculated item YTD will only be filled if the DayOfYear is less/equal of actual DayOfYear
Of course it all depends on the way you want to show your results and how your definitions of YTD etc. exactly are.
For MTD you can add that also the months are equal. etc.ect.
Greetings and good luck.
SAS INNOVATE 2024
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.
-
4574 views
-
1 like
-
-
