How is your layout designed and is the total field a summary field or a calculation?
This could be set up as a summary report with each items sub-total simply being a copy of the same summary field used for the grand total or you could have used separate fields for each item--which can be made to work but is not as flexible as a summary report.
The "Total" is just the grand total of the layout, but not necessarily the number of records in the database. All the layout is is a report with grouped data, grouped by the category of the item.
Therefore total is a "total of" summary field?
You layout has this structure? (substitute your field names for mine).
SubSummary when sorted by category------
Trailing Grand Summary--------
If so, define a new summary field as fraction of total, add it to your subsummary part and use number format to format the number as a percent.
thanks, that worked great. I dont know why ive never used that feature...