February 1st, 2013, 09:32 AM
Access 2003 Pivot Table Subtotal (or calculation) Help
Image to describe my problem is located:
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)...
Last edited by Shadow Wizard; February 3rd, 2013 at 06:38 AM.
Reason: embedding image
February 5th, 2013, 05:52 PM
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.
Last edited by June7; February 5th, 2013 at 05:57 PM.