Summary Layout of past sales

[Cabinetman]

Summaries are prob. my weakest point ... after portals that is.

I want to have my layout show past sales based on the item # and display in list format from the most sales to the least:

Total quantity for each item

Item #

Item name

Thanks....

[mr_vodka]

Create a self join keyed on ItemID. Create a calculation with Sum ( SelfJoin::Amt ). Sort by this field descending.

[comment]

I don't understand the question, but if the sort order should be based on found set data only, then:

http://www.filemaker.com/help/html/find_sort.5.22.html#1029044