Summarizing todays order

[bigmac]

What's the best approach to this problem:

I want to make the following summary, updated whenever a new order has been made:

Sales Guy 1: total order net today / total order net this month

Sales Guy 2: Total order net today / total order net this month

etc etc

The table i collect the information from contains sales guy name, order net total, and date. What is the best approach here?

[Søren Dyhr]

Subsummary reports seems pretty obvious here, however the calculations might require you use GetSummary( try to read in the "help" about the use.

This is for fm9, but it hasn't under gone many of any changes:

http://www.filemaker.com/help/FunctionsRef-342.html

--sd