From the course: FileMaker Pro Essential Training (2019)
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Creating subsummary reports: Aggregating Summary Parts - FileMaker Pro Tutorial
From the course: FileMaker Pro Essential Training (2019)
Creating subsummary reports: Aggregating Summary Parts
In previous movies we talked about the role of a summary field that gives us information about a found set. You'll see here on the bottom of the report, I have this field called Total Summary. And that is giving us information on all 146 orders that are currently in the found set. Now, if I go into Layout Mode, I'll see that I'm also using a layout part called Sub-summary when sorted by. One curious feature is a Sub-summary when sorted by creates mini-found sets and since a summary field aggregates a cross-found set, it'll do the same for mini-found sets. As a matter of fact, I'm just going to throw this up here real quick. I'm going to create a copy by option dragging or in Windows you can Control-drag. And I just want to show you what happens when I put that onto a sub-summary part. Without having to do anything, without having to create a new field, you see that it's now giving me not only the aggregate of all records in the found set which happens to be all 146 invoices at the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.