+ Reply to Thread
Results 1 to 5 of 5

Average of % in Grand Total

  1. 09-17-2018, 10:13 AM #1
    Dnyan
    Dnyan is offline
    Forum Contributor
    Join Date
    07-22-2011
    Location
    Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    185

    Question Average of % in Grand Total

    Hi All,

    I have a query regarding Pivot Table Grand Total.

    I have a data of handlers daily utilization. for Utilization %, in field Items-Calculated Fields I create Utilization % using (=SUM(AHT)/"09:00") this formula.
    Now I get correct percentage of utilization day wise.

    However In Grand Total its showing as Sum of all percentage, so instead of Sum in Grand Total I want Average of all percentage.
    I tried to change but not able to change this. when I right click the function of "Summarize Value by" option is grey out, so not able to change it.

    kindly help
    Reply With QuoteRegister To Reply
  2. 09-18-2018, 02:54 AM #2
    ramlineses
    ramlineses is offline
    Registered User
    Join Date
    08-17-2015
    Location
    Manila
    MS-Off Ver
    2013
    Posts
    10

    Re: Average of % in Grand Total

    Hi there,

    I believe the summarize value by option will be disabled if your values are from a calculated field. Did you use calculated field in
    Reply With QuoteRegister To Reply
  3. 09-18-2018, 06:35 AM #3
    Dnyan
    Dnyan is offline
    Forum Contributor
    Join Date
    07-22-2011
    Location
    Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    185

    Re: Average of % in Grand Total

    Yes, Utilization % calculated using "Calculated Field", so is there any option?
    Reply With QuoteRegister To Reply
  4. 09-22-2018, 08:52 AM #4
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,563

    Re: Average of % in Grand Total

    Found this thread from a few years back that may be relevant to your question.
    We might be able to provide better help if you could upload a sample of your raw data as well as a sample pivot table. To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  5. 09-23-2018, 01:23 AM #5
    FDibbins
    FDibbins is online now
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,935

    Re: Average of % in Grand Total

    Just a note that calculating an average of percentages is mathematically incorrect. A percentage is basically an average (x/y), and you cannot take an average of averages.
    You need to sum both x and y, then get the % of those totals.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    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. Issue with average in grand total
    By grkchakri in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-04-2016, 01:01 AM
  2. Pivot Table Grand Total Average
    By temexcel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2014, 02:32 PM
  3. Pivot Table, Need Grand Total as an average
    By children in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-13-2014, 01:37 PM
  4. [SOLVED] Is it possible to have both Grand Total and Grand Average in a Pivot Table?
    By ANS in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 10-16-2012, 05:15 AM
  5. Pivot Table Grand Total on Average
    By kmlloyd in forum Excel General
    Replies: 0
    Last Post: 03-16-2011, 12:21 PM

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