I have a file with around 1.4 million records. Each contains information on the person who placed the order including their ID number and the amount saved. (There is a lot of other info but it's not relavent to this problem.) I want to find the top 200 people who place an order based on the number of orders they placed, find out how many orders they placed and their total savings. Then I will send them a letter with a special offer.
I know I could brute force this by examining each record and running counters, etc. I am looking for a more elegant and less time consuming way to find the top 200. The mail merge is not a problem.
I am running FM 12 on a Mac with 10.7.5.
Thanks for any ideas