+ Reply to Thread
Results 1 to 1 of 1

Help with Pivot Tables to merge two tables

  1. #1
    Registered User
    Join Date
    04-05-2013
    Location
    Perth, Australia
    MS-Off Ver
    2013
    Posts
    30

    Help with Pivot Tables to merge two tables

    Hi all,

    I'm working with two sheets, each has a table on them, each row listing: invoice number; customer name; invoice date; product sold; and sale amount. The separate sheets are from different time periods.

    I would like to create a pivot table that consolidates the customer names and gives me total sales for each customer, with varying details underneath.

    I don't know a lot about pivot tables, but when I use data from two tables, it shows one table correctly, listing each customer with totals, but if I try to add another table, it simply puts all the customers from other sheet underneath the first entry and so on..

    How can I get it to recognize the customer name on each sheet and consolidate them, then show totals? I've tried to create a relationship between tables, however, as each customer is listed multiple times on each sheet, it doesn't work. Thank you so much in advance.
    Last edited by scrawl.to.me; 10-26-2015 at 06:10 AM.

+ 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. Excel Automation: Updating Pivot Tables, Charts, and Tables
    By Lemguin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2015, 04:25 AM
  2. Creating a Master / Consolidated Pivot Tables from a multiple pivot tables
    By paradise2sr in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-12-2013, 02:28 AM
  3. Creating a Master / Consolidated Pivot Tables from a multiple pivot tables
    By paradise2sr in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-08-2013, 10:49 PM
  4. Pivot Tables - need to do separate pivot tables for multiple sheets in same format
    By tconnell1965 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2013, 07:04 AM
  5. Validating Data Between 2 Pivot Tables (Pivot Tables Don't Line Up)
    By JohnGC84 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-18-2013, 05:07 PM
  6. Replies: 0
    Last Post: 09-22-2012, 07:22 PM
  7. [SOLVED] Merge Pivot Tables
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 06-13-2005, 09:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1