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