Great community. Great ideas.
Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.
February 1st, 2013, 08: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 05:38 AM.
Reason: embedding image
February 5th, 2013, 04: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 04:57 PM.
By GregBG in forum Microsoft Access Help
Last Post: January 4th, 2012, 08:10 AM
By 1943 in forum Microsoft Access Help
Last Post: February 16th, 2011, 12:15 PM
By vb707 in forum Microsoft Access Help
Last Post: January 23rd, 2007, 09:44 PM
By maverick_me84 in forum Microsoft Access Help
Last Post: November 22nd, 2006, 06:52 AM
By budlin00 in forum Microsoft Access Help
Last Post: October 25th, 2006, 11:04 PM