Link to home
Avatar of Jim Coleman
Jim ColemanFlag for United States of America

asked on

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?

User generated image
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
Avatar of James0628
James0628

Blurred text
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.
See Pricing Options
Start Free Trial