Notices

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.

Thread: Access 2003 Pivot Table Subtotal (or calculation) Help

Results 1 to 2 of 2
Share This Thread →
  1. #1
    numus is offline Registered User
    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
    June7's Avatar
    June7 is offline Moderator
    Join Date
    Apr 2009
    Location
    The Great Land
    Posts
    4,618
    Rep Power
    649
    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

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

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

ASP Free Advertisers and Affiliates