Thanks Beverly. We’ll take a look.

Jeff

On Jul 10, 2014, at 2:39 AM, Beverly Voth <[log in to unmask]> wrote:

> 1. This 
> 
> http://filemakerhacks.com/2012/09/13/aggregates-in-filtered-portals/
> 
> You can put summary fields in a portal and they will change based on the portal filter (in your case a date range).
> 
> Or 2. ExecuteSQL() to get the precise values you want. 
> 
> 
> -- sent from myPhone --
> Beverly Voth
> --
> 
>> On Jul 9, 2014, at 7:43 PM, Jeff Hough <[log in to unmask]> wrote:
>> 
>> Hello,
>> 
>> We are working on a report project that requires data sub summaries from 2 different date ranges to appear on the same page. For example:
>> 
>> Widget Name    |    Total Qty for June 2014    |    Total Sales for June 2014    |    Total Qty for June 2013    |    Total Sales for June 2013
>> 
>> Does anyone have an example they could send me to shortcut the work. This is proving to be more time consuming that originally planned.
>> 
>> Thanks,
>> Jeff

--
Jeff Hough * Two Southpaws, Inc. * 503.732.0101 * www.twosouthpaws.com * @jeffphough
Certified FileMaker 7/8/9/10/11 Developer