Mar 15, 2012; 11:34
Edwin Bullock
[FMPro] Find Top 10 values
Hi all
I have a table with about 700,000 records.
There's a field called Country.
I'd like to run a report which finds the Top 10 in this field. In other words which countries appear the most in this field from 1st to 10th.
There are too many distinct possibilities to count each unique value then sort in order to find the top 10.
Is there a function to perform this action?
Many thanks
#############################################################
This message is sent to you because you are subscribed to
the mailing list FMPro
FMPro@lists.lassosoft.com
To unsubscribe, E-mail to: <FMPro-unsubscribe@lists.lassosoft.com>
Send administrative queries to <FMPro-request@lists.lassosoft.com>
Mar 15, 2012; 11:49
Max Bonilla
Re: [FMPro] Find Top 10 values