Top 10 Bestseller Generation from LineItem DB

[kim_od]

I'd like to generate the "Top 10(or 20, 30,...etc) Bestsellers" from LineItem DB given date ranges. Working with date range is fine but I can't seem to figure out how to sort the Top (10,20,..30..etc) items. How do I sort through the summary field "_SubTotal" and Omit records?

Thanks in advance.

[kim_od]

Found a solution. In sort dialog box, there is a check box to include summary field. Once I sort it, then I can position the current cursor (using gotorecord())to the record that I want to omit from. Once the cursor is there, then use Omit Multiple using field value.

Thank you