February 21, 200817 yr I have made a database for a school project that lists all the affordable housing units in the country. Each record has the information of the developer that built the unit. I need to be able to list the top 10 developers that build the most units. In SQL there is a distinct count command, can someone please show me how to do this in FMP 9
February 21, 200817 yr Author That ranking function makes sense but in my case I am going off of unique phone numbers for developers. So how would I be able to show the "statistical mode" of these phone numbers? I thought about adding all the numbers to a global field and using a pattern count but not sure how to do it, or if this is even the right approach. Ultimately I would like to run a report that shows the top 10 developers that developed these housing projects.
February 21, 200817 yr Author doesn't look like the file will upload right off of my server must be a firewall problem
February 21, 200817 yr Try a report with a sub-summary by developer. You can re-order your sort by a summary field (which would be a count in this case).
Create an account or sign in to comment