+ Reply to Thread
Results 1 to 2 of 2

Pivot Table based on multiple Pivot Tables

  1. #1
    Registered User
    Join Date
    06-09-2014
    MS-Off Ver
    365
    Posts
    12

    Pivot Table based on multiple Pivot Tables

    I have two pivot tables: [CREDIT TBL] and [EMP TBL]. (see screenshot below)

    [CREDIT TBL] is the money I received from clients.
    [EMP TBL] is the money I paid employers.

    Both source tables ([tbl_clients] and [tbl_emp]) are structured completely differently so I don't see a way to combine them into one pivot table. (Since there is no relationship between them so no primary key to choose)

    What I really only need is a third pivot table that would look the same as the ones in the screenshot below but the values should be [CREDIT TBL] - [EMP TBL].
    This way, I would see the total profit (income - paying employers).

    I can't figure out how to create a third pivot table, based on the two current ones.

    Any help would be greatly appreciated.

    EXCEL_BDRCSWptN2.png
    Last edited by zvit; 01-23-2020 at 10:29 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Pivot Table based on multiple Pivot Tables

    Administrative note
    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
    Thanks

+ 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. Macro to update pivot table filters from multiple pivot tables of different data sources
    By groblerdn85 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2017, 05:10 AM
  2. pivot table, based on multiple tables
    By Nina07 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-17-2017, 05:32 AM
  3. Is it possible to make a Pivot Table from multiple Pivot Tables?
    By flapface in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-06-2014, 11:02 AM
  4. Multiple Pivot Tables from Master Pivot Table and Print as PDF - Need advise
    By vishnu01445 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2013, 02:07 PM
  5. Replies: 3
    Last Post: 02-27-2012, 08:03 PM
  6. Replies: 1
    Last Post: 08-13-2006, 07:51 AM
  7. [SOLVED] how do I consolidate multiple pivot tables into one pivot table?
    By pkahm in forum Excel General
    Replies: 0
    Last Post: 04-20-2006, 04:50 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1