+ Reply to Thread
Results 1 to 5 of 5

Pivot: How to get the average of Subtotal

  1. 10-04-2013, 06:03 PM #1
    Siops
    Siops is offline
    Registered User
    Join Date
    10-10-2012
    Location
    Philippines
    MS-Off Ver
    Microsoft Office 365
    Posts
    53

    Pivot: How to get the average of Subtotal

    Good day! I just want to ask if it's possible/how to get the average of the SUM Subtotal in Pivot?

    10-4-2013 3-01-24 PM.jpg

    I want to get the average of the WMV/Hour of 0.69, 1.95 and 0.39 WMV/Hour.
    Reply With QuoteRegister To Reply
  2. 10-06-2013, 03:08 PM #2
    RobertMika
    RobertMika is offline
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Pivot: How to get the average of Subtotal

    Have you tried Calcalted Field?
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk
    Reply With QuoteRegister To Reply
  3. 10-07-2013, 10:45 AM #3
    Siops
    Siops is offline
    Registered User
    Join Date
    10-10-2012
    Location
    Philippines
    MS-Off Ver
    Microsoft Office 365
    Posts
    53

    Re: Pivot: How to get the average of Subtotal

    Not yet sir. What's the formula for the calculated field?
    Reply With QuoteRegister To Reply
  4. 10-07-2013, 10:49 AM #4
    RobertMika
    RobertMika is offline
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Pivot: How to get the average of Subtotal

    Attached your workbook
    Reply With QuoteRegister To Reply
  5. 10-07-2013, 10:53 AM #5
    Siops
    Siops is offline
    Registered User
    Join Date
    10-10-2012
    Location
    Philippines
    MS-Off Ver
    Microsoft Office 365
    Posts
    53

    Re: Pivot: How to get the average of Subtotal

    Here you go sir.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Subtotal Average Multiple Sheets into a Summary Sheet
    By hornet77 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-10-2013, 11:11 PM
  2. [SOLVED] Macro that works like Subtotal Average, except for Mode
    By engineerlady in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2013, 09:56 PM
  3. subtotal and weighted average
    By matt3m in forum Excel General
    Replies: 5
    Last Post: 04-29-2012, 08:36 PM
  4. Subtotal Sum, and Subtotal Average on same row
    By ImpetuousRacer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-04-2008, 05:41 PM
  5. Subtotal average
    By iain_clark in forum Excel General
    Replies: 7
    Last Post: 03-07-2007, 10:33 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1