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