Results 1 to 4 of 4

Thread: one pivot table from two different excel table

  1. #1
    New Member
    Join Date
    Jun 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Smile one pivot table from two different excel table

    Hy Everybody,

    I am sure somebody can help me:

    I have an Excel Table with Price Data - Product Name, Quantity (piece, weight, etc), Price in Dollar, Price in Euro.
    I have an additional Excel Table with 7 Sheets (one weekday each), with Product Name, Company, Sale

    My Question is, how can i make a Pivot Table (one for the hole week) together with the Price Data?

    Thank You in advance
    Regards
    Tamas

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,818
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: one pivot table from two different excel table

    without seeing the data/structure I can't say more than: try Alt+D+P
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  3. #3
    New Member
    Join Date
    Sep 2010
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: one pivot table from two different excel table

    Quote Originally Posted by urvota View Post
    Hy Everybody,

    I am sure somebody can help me:

    I have an Excel Table with Price Data - Product Name, Quantity (piece, weight, etc), Price in Dollar, Price in Euro.
    I have an additional Excel Table with 7 Sheets (one weekday each), with Product Name, Company, Sale

    My Question is, how can i make a Pivot Table (one for the hole week) together with the Price Data?

    Thank You in advance
    Regards
    Tamas

    Would you be able to create another table that pulls the data from the other two tables using formulas and then create the pivot table from that?

  4. #4
    Board Regular
    Join Date
    Jul 2013
    Location
    Essex, UK
    Posts
    128
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: one pivot table from two different excel table

    Consolidate the sales data into a single table using Power Query or Data, Consolidate. Then start a Pivot Table based on this, and Add this data to the Data Model when you are creating the Pivot Table. This will allow you to display the Price data along with the matching Product information.
    Last edited by ClaireS; Jun 14th, 2019 at 12:00 PM.

    Helping you to Excel

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •