Filter by Count 1

[lkerr]

Here's what I want to do. I want to somehow filter my report to only show jobs with more than one item listed underneath. How can I do that? I know there's probably a formula for this, but I'm not sure how to reset the count with each group. I've tried using a running total but it will not accept it in the select expert. I'm at a loss. Any ideas?

Thanks!

 

[lbass]

Group on {table.job} and then go to report->edit selection formula->GROUP and enter:

count({table.item},{table.job}) > 1

If you want to do further calculations across groups, you will need to use running totals as inserted summaries will also count non-group selected records.

-LB