What version of Filemaker are you using?
Once you have sorted your records, your script can go to the 11th record and use omit multiple records to omit the 11th through end of found set records.
A 10 row portal might display these same records in sorted order and by limiting the portal to 10 rows, you show the top 10.
You might also list top ten data inside a large multi-row single field using ExecuteSQL.
Right now I have a calculation field that has a calculation
Case ( Clients::c_RecentWeight - Weight > -1 ; "" ; Clients::c_RecentWeight - Weight)
I get all the negative numbers but it shows all other names. How do I limit that to only 10. Tried figuring out how to use omit multiple records but cannot get that to work.
Cannot get that to work doesn't give me much to go on. How did it fail for you?
As a script, it would look similar to this:
Go to record/reqeust/page [11 ; no dialog ] --> use the record number by calculation option
Omit Multiple Records [Get ( FoundCount ) ; no dialog ]