Access 2003 Pivot Table Subtotal (or calculation) Help

[numus]

Image to describe my problem is located:

I2N7c72.png

I am trying to get a Subtotal count on how many actvnum exist... In the image I have 13 showing but the subtotal comes out at 25 (the number of total violations inside those 13 actvnum). Is there a way to get it to output 13? I am trying to calculate percent of violations per inspection (actvnum is the unique number for an inspection)...


Any help?

[June7]

Wouldn't the percentage violations calc for actvnum 41550 be: 7 / 25 ? Why do you need the total of actvnum (13)? The 13 could be used for an average calc: 25 / 13.

I don't think can be done with pivot table view unless the summary values (25 and 13) were showing on every record. Is this pivot table on table or query? A query could calculate the aggregate values and show on each record. Use subqueries or domain aggregate functions.