Month to date data for Previous month
How can I get the previous month to date data to show so that I can compare previous month performance to current month performance. For example:
On May 17, we had made 1156 transactions so far for the month. How many had we made for the month of April on April 17?

Ideally it would be automatic using "currentdate" as the trigger so no parameter is required. ("currentdate-30" may not always be the right answer.)
On May 17, we had made 1156 transactions so far for the month. How many had we made for the month of April on April 17?

Ideally it would be automatic using "currentdate" as the trigger so no parameter is required. ("currentdate-30" may not always be the right answer.)
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
