+ Reply to Thread
Results 1 to 4 of 4

Pivot table problem - how to relate 3 sheets' data into 1 pivot table?

  1. #1
    Registered User
    Join Date
    08-31-2015
    Location
    Belgrade
    MS-Off Ver
    8.1
    Posts
    22

    Pivot table problem - how to relate 3 sheets' data into 1 pivot table?

    Hi Friends,

    I have one problem.
    I have pivot table with 3 sheets and data in each of them.
    I want to relate those data so that when I call one element that all 3 sheets contains in that pivot table, it shows data related to that element from all 3 sheets.
    I made 3 pivot tables 1 table = 1 sheet, but it would be great if I would get the idea how to have only 1 pivot table.
    If not possible in my case, I would like to know how to call the same element in all 3 pivot tables by 1 click on the slicer, and not to call it separately in each pivot table.

    To be more clear, I'm sending file attached with explanation in it.

    Thanks,
    Stevan
    Attached Files Attached Files

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Pivot table problem - how to relate 3 sheets' data into 1 pivot table?

    To be able to do that, you need to use Vlookups/Or some other lookup function and have all the data from 3 sheets on a single sheet, which will then be used as source data for the Pivot Table.

    Or you will have to use Power Pivot/Excel's Data Model to build relationships between tables..

    For that, you will need your data properly arranged with related keys..

    But, I see that your data is quite weirdly arranged..
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    08-31-2015
    Location
    Belgrade
    MS-Off Ver
    8.1
    Posts
    22

    Re: Pivot table problem - how to relate 3 sheets' data into 1 pivot table?

    Thanks, actually I hoped that you can help me about Power Pivot model.
    How to arrange data properly?
    Is there a pattern for that? And how to relate keys after that?
    Thanks,
    Stevan

  4. #4
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Pivot table problem - how to relate 3 sheets' data into 1 pivot table?

    Which version of Excel do you use?

    This should give you an idea

    https://support.office.com/en-us/Art...0-5c75dbcb0f7b

+ 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. Replies: 0
    Last Post: 08-14-2013, 06:31 AM
  2. [SOLVED] Filtering Data Pivot Table is Based On - Impact on Pivot Table
    By bbg22 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-17-2013, 06:34 AM
  3. Calculated pivot table field using pivot table data in calculation
    By BrittleStar in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-10-2012, 05:35 PM
  4. Pivot table - change data source to another pivot table in 2010
    By thesecretsanta in forum Excel General
    Replies: 4
    Last Post: 04-13-2011, 12:54 PM
  5. Replies: 1
    Last Post: 06-22-2010, 09:10 AM
  6. Replies: 1
    Last Post: 06-20-2010, 04:00 AM
  7. Return pivot table range...not the data table, the PIVOT TABLE!
    By Air_Cooled_Nut in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2008, 01:07 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