Possible and a classic example of why you would create such a summary report in the first place.
- Define a summary field that computes the "total of" your royalty field if you have not already done so.
- On you list view layout, add a sub summary part "when sorted by" your CD title field.
- Place the summary field in this sub summary part.
- Return to browse mode and sort yoru records by the CD title field to see the sub totals in the sub summary part.
Note: if You are using FileMaker 9 or earlier, you must either print or preview your report to see the sub totals.
When in browse mode this will only show the sub summed totals. What I need is all the single record totals and then a sub summed total of each cd title on the same view. Not sure if this is possible? I am using FM 9.
Any help would be much appreciated.
With FileMaker 9, you must view the report in Preview Mode (And the records must be sorted correctly). In Preview mode or when you print it, you should see both the sub totals and the individual titles not just the sub summary totals.
In Browse mode, you won't see the sub summary parts at all with your version of FileMaker.