David Jondreau Posted October 17, 2014 Share Posted October 17, 2014 I've got a line items report showing sales for a quarter, summarized by County. I'm trying to figure out how, on this same report, to show a count of invoices on the subsummary part as well. Invoices are parents of Line Items. Don't know why I'm blanking on this. I feel like it should be pretty simple. Any ideas? Link to comment Share on other sites More sharing options...
comment Posted October 17, 2014 Share Posted October 17, 2014 (edited) I feel like it should be pretty simple. I am afraid it's not. In fact, I always find this post by searching for "tricky": http://fmforums.com/forum/topic/61158-number-of-employees-from-payroll-report/?p=289204 New alternative for version 13: You can (1) define a summary field as List of [invoiceID], (2) filter a value list of InvoiceIDs by the sub-summary value, and (3) count the resulting values. --- BTW, why can't you summarize the invoices instead? Edited October 17, 2014 by comment Link to comment Share on other sites More sharing options...
David Jondreau Posted October 17, 2014 Author Share Posted October 17, 2014 Line Items have categories that are independent of the parent Invoice. I was trying to get one report layout to do double duty on Categories and Counties (which are tied to the invoice). So I could change the sort order and have a report on Category or on County. But I only need the invoice count on County, so it looks like I'll need two layouts. DJ Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3472 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now