• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 527
  • Last Modified:

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.  

1 Solution
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.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now