From the course: Advanced FileMaker Pro 12

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Creating a crosstab report

Creating a crosstab report - FileMaker Pro Tutorial

From the course: Advanced FileMaker Pro 12

Start my 1-month free trial

Creating a crosstab report

SubSummary reports like those covered in the previous movies will solve many of your reporting needs in FileMaker but there are some report formats that don't necessarily work that well in these SubSummary report or grouped format. Say for instance we are looking at the Invoice Summary No Body part layout in the exercise file. Our output is going to look like a column that has the customers and the other column shows the total invoice sales for whatever the time period is reflected in the found set. The report represents the correct data but a SubSummary report only displays subgroups as rows in a list. So a more convenient output format for most users would be what a lot of people refer to as a Crosstab report or a lot of people imagine when they think of a pivot table. A Crosstab report presents a summary of information both rows and columns, so you can see sort of the intersection of a row and the column will mean a specific piece of information. In this format it's much easier to…

Contents