+ Reply to Thread
Results 1 to 4 of 4

Combine 2 different pivot tables into one

  1. #1
    Registered User
    Join Date
    03-15-2019
    Location
    Malta
    MS-Off Ver
    Office 2016
    Posts
    9

    Combine 2 different pivot tables into one

    Hi all,

    I don't know if it's possible but I am trying to find a way to combine 2 different pivot tables into a one.

    I have the following pivot tables:
    1) ROWS: Employee number (#)
    VALUES: Count of Outgoing calls, SUM of Sales
    Filters: Date

    2) ROWS: Employee number (#)
    VALUES: Count of Outgoing calls - that finished their sale
    FILTERS: Date, Finished at (Date)

    -- The only different between these 2 pivots is the "Finished at" in the filters.

    Is it possible to combine them into a one pivot table?


    Many thanks

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: Combine 2 different pivot tables into one

    Should be possible....Especially if the Column headings are EXACT. It would be best on the COUNT to have zero's instead of BLANKs (then you could easily add (Sum)the Counts of Outgoing calls. What I typically do, is insert another tab, Range Value the 2nd Pivot Table below the 1st Pivot table....then create a new Pivot Table off of that OR combine the ORIGINAL Data Sets as a new Pivot Table (if you use the later, then if you update the data it will update the Pivot Table (if you hit REFRESH).

  3. #3
    Registered User
    Join Date
    03-15-2019
    Location
    Malta
    MS-Off Ver
    Office 2016
    Posts
    9

    Re: Combine 2 different pivot tables into one

    Thanks for that.

    There is no better way to do that? because I need to do it on a daily basis and I'm scared that from time to time I will miss something...

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Combine 2 different pivot tables into one

    Linked below is an article that may help.
    https://www.techwalla.com/articles/h...e-pivot-tables
    Best of luck.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. How to combine pivot tables into a new worksheet?
    By mukii in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-03-2019, 11:25 AM
  2. Combine multiple tables into one pivot
    By KeighlR in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-07-2018, 10:36 AM
  3. Power Pivot to Combine Multiple Pivot Tables
    By chrapm1 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-07-2018, 04:20 PM
  4. PLEASE HELP! Trying to combine 2 Pivot Tables
    By alesha711 in forum Excel Charting & Pivots
    Replies: 19
    Last Post: 01-29-2018, 10:28 AM
  5. How can I combine multiple tables into one pivot table?
    By crsport3 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-21-2013, 02:53 PM
  6. Combine Two Pivot Tables
    By whiteheadw in forum Excel General
    Replies: 0
    Last Post: 09-21-2009, 06:29 PM
  7. Combine pivot tables?
    By jjjjj55555 in forum Excel General
    Replies: 0
    Last Post: 02-25-2007, 10:50 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