+ Reply to Thread
Results 1 to 10 of 10

How to get average of grand total in pivot table, without added extra columns

  1. #1
    Registered User
    Join Date
    07-13-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2013
    Posts
    5

    How to get average of grand total in pivot table, without added extra columns

    Hello Everyone,

    Could you please help me on the below question?

    "How to get average of grand total in pivot table, without added extra columns".

    Many thanks in advance for help.

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,783

    Re: How to get average of grand total in pivot table, without added extra columns

    You can right click and summarize data by Average.. But that will give you average of all the data aswell..
    Cheers!
    Deep Dave

    www.NeedForExcel.com

  3. #3
    Registered User
    Join Date
    07-13-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: How to get average of grand total in pivot table, without added extra columns

    Many thanks for your reply.

    But probably i am looking for a single column in the table that shows average of grand total and the rest data should remain the same..

  4. #4
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,783

    Re: How to get average of grand total in pivot table, without added extra columns

    "How to get average of grand total in pivot table, without added extra columns".
    Can we add an Extra Row, below the Grand Total?

  5. #5
    Registered User
    Join Date
    07-13-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: How to get average of grand total in pivot table, without added extra columns

    Yes, that is not a problem, an extra row can be added.

  6. #6
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,783

    Re: How to get average of grand total in pivot table, without added extra columns

    Hi,

    If your Pivot is starting from the 3rd Row, try this on cell B2 -

    Please Login or Register  to view this content.
    Let me know if it doesn't work..

  7. #7
    Registered User
    Join Date
    07-13-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: How to get average of grand total in pivot table, without added extra columns

    Hey Friend, Many thanks, the formula works perfectly,

    However, i require something like it should be a part of pivot table. so that i can sort the data according to the average. using external formulas i am unable to use the sort function.

  8. #8
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,783

    Re: How to get average of grand total in pivot table, without added extra columns

    If you want it to be a Part of the Pivot Table, all values will have to be averaged.. Like, you cant have the values as Sum and the Grand Total as Average..

    That's to the best of my knowledge I am saying. If there is a workaround, I am not aware of it..

  9. #9
    Registered User
    Join Date
    07-13-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: How to get average of grand total in pivot table, without added extra columns

    Dear, many thanks for your help.

  10. #10
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,783

    Re: How to get average of grand total in pivot table, without added extra columns

    Thank You

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot Table Grand Total Average
    By temexcel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2014, 02:32 PM
  2. 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
  3. [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
  4. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1