if there are just those 3 types of records, I would 1)create a group on the field that is common to all 3 records. 2) created global variables that would hold the values for each part of the index, and increment these variables in the details section. 3) suppress the detail section. 4) in the group footer, create the layout that you want, and create formulas to access your global variables and use them in the group footer. Last, I would go back to the group header and add a formula to rest all the variables to 0.
That should solve the simple problem of the display. If grand totals or other totals are desired, I would create more global variables; resetting, incrementing, and displaying them as needed.
HTH
IP Logged
