Having trouble with subsummaries on FM6

[abuencam]

I've created a report using a few subsummary sorts. It sorts by category then by code. So my lines look like this:

Category 7 Records $2100

Code 1 3 records $900

Code 2 4 records $1200

Catgory 2 3 Records

Code 1 1 Record

Code 2 2 Record

I need to find out how I can put a formula into the subsummary without it calculating all records instead of records shown. I'm not sure if I understand my own question but any help would be greatly appreciated.

Thanks

[-Queue-]

You'll need a global text field, a relationship from the global to your serial (unique id) field, a layout that contains only the serial field, and a layout that contains the global field (it doesn't have to be the only field; it just has to be present). When you view the report, use a script that goes to the layout holding the serial field, copies all records (using the Copy All Records step), goes to a layout holding the global, and Pastes [select] into the global field. Now your global field relates only to records in the found set. Therefore, any Count or Sum calculations that reference this relationship will only tally fields in the found set.