+ Reply to Thread
Results 1 to 1 of 1

VBA Grand Average Pivot Table

  1. 10-22-2015, 10:47 PM #1
    IlhamideaZ
    IlhamideaZ is offline
    Registered User
    Join Date
    10-22-2015
    Location
    Malaysia
    MS-Off Ver
    2010
    Posts
    1

    Red face VBA Grand Average Pivot Table

    Hi!
    How can I get both Grand Total and Grand Average in Pivot Table using MACRO for this xls sheet?
    Actually it is sorted based on Date 1 Month, then the average produced based on ((Date2-Date1)/Total Cases of Month based on Date 1).
    I'm actually able to do the sorting and Grand Total using MACRO but already stuck for many days on Average.
    Thanks!
    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. 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
  5. Grand Average of counts in pivot table
    By ruchi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2009, 06:55 AM
  6. [SOLVED] Grand Average in Pivot Table?
    By mikelee101 in forum Excel General
    Replies: 5
    Last Post: 01-22-2006, 04:45 AM

Tags for this Thread

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