Subsummary Count of related Parents

[David Jondreau]

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?

[comment]

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

[David Jondreau]

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