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

    Join Date
    Feb 2013
    Posts
    6
    Rep Power
    0

    Access 2003 Pivot Table Subtotal (or calculation) Help


    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?
    Last edited by Shadow Wizard; February 3rd, 2013 at 05:38 AM. Reason: embedding image
  2. #2
  3. Moderator
    ASP Super Genius (4500 - 4999 posts)

    Join Date
    Apr 2009
    Location
    The Great Land
    Posts
    4,618
    Rep Power
    650
    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.
    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.
    Debug!Debug!Debug!http://www.cpearson.com/excel/debug.htm

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, 08:10 AM
  2. Calculation in a form Access 2003
    By 1943 in forum Microsoft Access Help
    Replies: 3
    Last Post: February 16th, 2011, 12:15 PM
  3. Importing Excel table to Access 2003
    By vb707 in forum Microsoft Access Help
    Replies: 1
    Last Post: January 23rd, 2007, 09:44 PM
  4. Pivot Table in Access!
    By maverick_me84 in forum Microsoft Access Help
    Replies: 0
    Last Post: November 22nd, 2006, 06:52 AM
  5. Pivot Table on a Query in Access 2000?
    By budlin00 in forum Microsoft Access Help
    Replies: 1
    Last Post: October 25th, 2006, 11:04 PM

IMN logo majestic logo threadwatch logo seochat tools logo