Title
Limit SubSummary Report to Top 10
Post
Is there a way to limit the limit the scope of a Sub Summary report to show only the Top 10 values or rows in the report?
I have a sub summary report that ranks the most commonly mentioned "Issues" mentioned in customer surveys. I would like to create a new report identical to the first but limiting the report to the Top 10 issues.
I will assume that you've figured out how to reorder the Sub summary groups to list the groups with the largest sub total first.
If so, then a script could loop through the records in your found set starting with the first record, adding one to a counter each time a new value in the break field is encountered--marking the start of the next sub summary group. Exit the loop when the counter = 11, which leaves the first record of those you want to omit from your report as the current record.
Then Omit Multiple Records can omit that record and all that follow from the found set to limit your report to the top ten summary groups.
When I script such an "omit", I use Get ( FoundCount ) to specify the number of records to omit. This assures that I am always specifying a number greater than the number of records from the current record to the end of the found set and thus I am sure that they will all be omitted.
Caulkins Consulting, Home of Adventures In FileMaking