We use Filemaker to keep track of orders, sales, etc. We have many repeat customers. Each order is a seperate order form and invoince. I would like to learn how to calculate the total sales from a particular customer.
Joe has placed 30 orders from 2012 - 2013. I want to learn the total sales $ of all of Joe's sales.
Can anyone assist?