Results 1 to 12 of 12

Getting a Grand Average of Counts in a Pivot Table next to the default Grand Total

Threaded View

e4excel Getting a Grand Average of... 07-07-2019, 12:21 AM
VKS Re: Getting a Grand Average... 07-07-2019, 11:03 AM
e4excel Re: Getting a Grand Average... 07-07-2019, 12:44 PM
e4excel Re: Getting a Grand Average... 07-07-2019, 01:10 PM
e4excel Re: Getting a Grand Average... 07-14-2019, 09:12 AM
romperstomper Re: Getting a Grand Average... 07-15-2019, 04:58 AM
e4excel Re: Getting a Grand Average... 07-27-2019, 01:47 AM
e4excel Re: Getting a Grand Average... 09-04-2019, 04:56 AM
e4excel Re: Getting a Grand Average... 09-22-2019, 10:03 AM
romperstomper Re: Getting a Grand Average... 09-23-2019, 07:09 AM
e4excel Re: Getting a Grand Average... 09-26-2019, 11:50 AM
romperstomper Re: Getting a Grand Average... 09-27-2019, 08:00 AM
  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Getting a Grand Average of Counts in a Pivot Table next to the default Grand Total

    Dear Forum,

    I need to get the Average of the Counts used in my Pivot Table, I have three Column Data
    1. Col A- Branch - Name of the Branches
    2. Col B- File No - Actual File Nos
    3. Col C- Month- Contains Apr-19,May-19,Jun-19 and Jul-19

    Now I have the Branch in my Row Section of the Pivot table, the Month in the Column Section and the File No in the Data Values where I am taking the Count.
    I get the Grand Total by default, however I need to get the Average of the Counts of File Nos of the months in consideration.
    I managed to do somehow using a Calculated Item however I have to manually add all the items of the months , I need a mechanism where the months get added automatically each month once the data increases every month as this is Year-To-Date Data.

    In my workaround, I have created a Calculated Item to get the Grand Average of Counts and also the Grand Total , however it does not include any new months added in the data as I need to manually add it to the items, so is there a workaround without using any helper Columns in the data as i need to get this as a ready-made structure in the Pivot Table.

    I can always do the Average Calculation next to my Pivot table however I need it as a part of the Pivot table.

    Warm Regards
    e4excel
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Pivot Table Grand total issue need two grand totals
    By alesha711 in forum Excel Charting & Pivots
    Replies: 18
    Last Post: 02-13-2019, 03:02 PM
  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
  6. Grand Average of counts in pivot table
    By ruchi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2009, 06:55 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1