AnsweredAssumed Answered

Displaying different subsummaries for a data set

Question asked by sabremm on May 7, 2018
Latest reply on May 9, 2018 by erolst

I am trying to display on a layout the summary of sales in date ranges for comparison purpose:

For example:

                    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.

Outcomes