5 Replies Latest reply on Jan 23, 2013 12:13 PM by Stephen Huston

    Find only top X number of results based on sub-summary values

    gmint

      I've recently encountered something that I haven't been able to figure out myself or through various Google searches. Hopefully someone will be able to help me with this one. First, let me say that summary/sub-summary stuff has always been my weak point in FMP, so please forgive me if this is a novice question. That said, here it goes:

       

      I'm generating a report which does a count of items sold and then summarizes them into a list so I can see what items are most popular. The problem is that the list includes ALL of my items when what I really want is only the first X (let's say 20) items (essentially my best sellers). I don't really care about the items that I've sold only one or two of. When I'm just doing a list, that's not a real problem (and it works fine) but I'd like to put that in a chart which means that I'm going to need to eliminate all of the extraneous data. In other words, I need a way to omit all of the records which are not best sellers.

       

      Any ideas on an elegant solution would be greatly appreciated?