Aggregate Sums in Filemaker

Posted on 2006-04-06
Last Modified: 2008-03-17
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.  

Question by:rgjutro
    LVL 19

    Accepted 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.

    LVL 28

    Expert Comment

    If you just want to print it, a layout with a subsummary is enough.

    Author Comment

    Thanks bill,

    That's exactly what I'm looking for.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now