Aggregate Sums in Filemaker

I've been doing this manually for years, and I cant' stand it any longer.  I'll give an example of the type of aggregate summary's that I'm looking for.  Let's say I'm running a bookings report for the year of 2005.  I want to be able to have it automatically calculate the total dollar values based on Customer Name and only for the year of my choice.  I can kind of get close to that now, but I still have to export the data into excel pivot table in order for me to have the dollars roll up on the customer name. I can never seem to get that last part to work.  Once I can get a solution for this, I'll be able to use it for a lot of different reports that I've been running for too long.  

Who is Participating?
Take a look at this simple example, and see if I'm understanding you correctly.

It uses a self-join relationship and the Sum() function to return the total for a given customer and a given date range. The sum is based on a self-join relationship based on the customer name and an arbitrary date range stored in two global fields.

If you just want to print it, a layout with a subsummary is enough.
rgjutroAuthor Commented:
Thanks bill,

That's exactly what I'm looking for.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.