I am trying to display on a layout the summary of sales in date ranges for comparison purpose:
Current Month Last 3 Months Last 12 Months
Apple 10 50 140
Pear 5 25 36
Banana 45 100 325
I figured out how to set the date ranges based on current date. If today's date is 5/10/2018, first column would reflect 5/1 through 5/10, second column 2/1 through 4/30, and third column 5/1/2017 through 4/30/2018.
How do I use the Perform Find command to find these different set of subsummaries? Also, is Perform Find the right command to use ?
Thanks in advance for your response.