i want cumulative revenue comparison between two financial year with respect to a particular month & day
for example - cumulative sum of revenue for financial year 2020-21 (till October 2oth )
with financial year 2021-22 (till October 2oth )
Note : Year starts from 1st of April ends with 31march .
Hi @SonaliSahoo ,
here (SAS Visual Analytics Advanced Calculations (part 1... - SAS Support Communities) you can find a very good treatment of your question (series of 4 posts).
Thanks for the suggested blog.
But still i am not able to achieve my required goal.
To be more specific , i need year to date cumulative sum comparison (starting from 1st of April to any date i can put in my wish , which can be applied for any two financial years ).
I would need to prepare an example before a call. But at the moment I don't have access to my VA installation.
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.