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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.