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 perform comparative analyses and…