Thanks Beverly. We’ll take a look. Jeff
On Jul 10, 2014, at 2:39 AM, Beverly Voth <[email protected]> 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 <[email protected]> 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
