
1. Re: Find only top X number of results based on subsummary values
Stephen Huston Jan 18, 2013 1:11 PM (in response to gmint)One solution might be to search a calculation field which returns the subsum values, for all items with a subsum > X.
That should limit your found records to those you want to chart in the report.
You could do your regular search for sold items, then contrain the search to items with the subsum > X,
or you can build the subsum number criteria into the original search as an AND criteria.

2. Re: Find only top X number of results based on subsummary values
comment Jan 18, 2013 1:42 PM (in response to gmint)You cannot do a find using find results as the criteria. However, you can sort your records by the subsummary value (i.e. by popularity in your example), then loop over the found set until you reach the less popular items which you can then omit.
A quick way to do the loop is to use a method known as "Fast Summaries" where you jump directly to the next group using =
GetSummary ( sCount ; Item)
to calculate the size of the current group (i.e. the number of records to jump).

3. Re: Find only top X number of results based on subsummary values
comment Jan 18, 2013 1:53 PM (in response to Stephen Huston)Stephen Huston wrote:
One solution might be to search a calculation field which returns the subsum values, for all items with a subsum > X.
That should limit your found records to those you want to chart in the report.
You could do your regular search for sold items, then contrain the search to items with the subsum > X,
or you can build the subsum number criteria into the original search as an AND criteria.
What would be the formula for this calculation field?

4. Re: Find only top X number of results based on subsummary values
gmint Jan 18, 2013 6:52 PM (in response to comment)Michael,
Thank you! That's EXACTLY what I was looking for! I had a feeling it could be done the way you describe but I wasn't aware that GetSummary could be used in that manner. Perfect!
Thanks again!

5. Re: Find only top X number of results based on subsummary values
Stephen Huston Jan 23, 2013 12:13 PM (in response to comment)I was assuming that the sum would be calculated via a relationship based on the item type. Your solutions is much simpler.