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