1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Feb 2013
    Rep Power

    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)...

    Any help?
    Last edited by Shadow Wizard; February 3rd, 2013 at 06:38 AM. Reason: embedding image
  2. #2
  3. Moderator
    ASP Super Genius (4500 - 4999 posts)

    Join Date
    Apr 2009
    The Great Land
    Rep Power
    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.
    I like to know if my suggestion helped you. One way to let me know is by clicking star at bottom left corner of post.

Similar Threads

  1. Saving an access pivot table exported into excel
    By GregBG in forum Microsoft Access Help
    Replies: 2
    Last Post: January 4th, 2012, 09:10 AM
  2. Calculation in a form Access 2003
    By 1943 in forum Microsoft Access Help
    Replies: 3
    Last Post: February 16th, 2011, 01:15 PM
  3. Importing Excel table to Access 2003
    By vb707 in forum Microsoft Access Help
    Replies: 1
    Last Post: January 23rd, 2007, 10:44 PM
  4. Pivot Table in Access!
    By maverick_me84 in forum Microsoft Access Help
    Replies: 0
    Last Post: November 22nd, 2006, 07:52 AM
  5. Pivot Table on a Query in Access 2000?
    By budlin00 in forum Microsoft Access Help
    Replies: 1
    Last Post: October 26th, 2006, 12:04 AM

IMN logo majestic logo threadwatch logo seochat tools logo