+ Reply to Thread
Results 1 to 2 of 2

Using Grand Totals of 2 pivot tables in a formula.

  1. #1
    Forum Contributor
    Join Date
    03-03-2011
    Location
    Ottawa, Ontario
    MS-Off Ver
    365
    Posts
    136

    Using Grand Totals of 2 pivot tables in a formula.

    I have 2 pivot tables that have the same column names and I would like to be able to sum the grand totals for each column. eg. Table 1 has 3 columns: Div 1 - Div 2 - Div 3 and Table 2 has 3 columns: Div 1 - Div 2 - Div 3. I need the add the grand total of Table 1-Div 1 to Table 2-Div1 and display elsewhere on the sheet (M:30 for example). The size of each table changes depending on what is selected by the slicer for each one so I am not sure how to do this. Thanks for any help.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Using Grand Totals of 2 pivot tables in a formula.

    have you tried getpivotdata formulas?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ 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. The average formula in pivot tables keeps using the Grand Total amount
    By Geoles in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 05-05-2013, 08:39 PM
  2. Pivot Tables - Grand Totals
    By Tony in forum Excel General
    Replies: 2
    Last Post: 05-31-2006, 09:10 AM
  3. Need help with grand totals in pivot table
    By Missygal in forum Excel General
    Replies: 1
    Last Post: 05-16-2006, 02:10 PM
  4. [SOLVED] Pivot Table Grand Totals??
    By Adam in forum Excel General
    Replies: 0
    Last Post: 03-25-2005, 01:06 PM
  5. [SOLVED] Pivot Table Grand Totals
    By Adam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-25-2005, 01:06 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