+ Reply to Thread
Results 1 to 6 of 6

Connecting two or more pivot tables from one slicer

  1. #1
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Connecting two or more pivot tables from one slicer

    Hey All..

    can anyone help me to know how two or more pivot tables can be connected through one slicer.

    I have four differnt tables ( Table1, Table2, Table3 and table4) having the same kinds of data source and column heading and also pivot tables extracted from it.

    Now, i have made a pivot chart from pivot table 1 but can i insert a slicer (REGION field) with connection that if i choose "ASIA" from slicer it would display all "ASIA" details from table 1,2,3 and 4..

    Also it would be great if i can connect timeline just like slicer.. I would be able to choose year from timeline like 2013 or 14 or 15 or 16 and the charts would change according to that..

    Any help would be appreciated thanks

  2. #2
    Registered User
    Join Date
    03-26-2013
    Location
    KUWAIT
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Connecting two or more pivot tables from one slicer

    Share your excel file!
    i believe this can be done easily in Power Pivot.

  3. #3
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Connecting two or more pivot tables from one slicer

    In the Options tab - on the left - Connection Report

  4. #4
    Forum Contributor meus's Avatar
    Join Date
    11-25-2014
    Location
    kathmandu
    MS-Off Ver
    2010/ 2013
    Posts
    287

    Re: Connecting two or more pivot tables from one slicer

    No i tried the connecting report.. Not helped..
    Any one has genuine idea please?

  5. #5
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Connecting two or more pivot tables from one slicer

    You can only connect a slicer to pivot tables that share the same data source. That doesn't sound like it's the case here, so you'd have to use code.
    Remember what the dormouse said
    Feed your head

  6. #6
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Connecting two or more pivot tables from one slicer

    See if sometimes did not create one of the tables (even based on the same source) by selecting "Add data to the data model." Then the connection is not working.

+ 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. Connecting Sloicer from Power Pivot to Slicer from Regular Pivot
    By rv02 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-27-2015, 06:13 AM
  2. Is It Possible to Connect A Slicer to Two Pivot Tables?
    By NewJerichoMan in forum Excel General
    Replies: 2
    Last Post: 04-26-2015, 01:35 PM
  3. Slicer on Tables
    By cfleming13 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-04-2015, 04:59 AM
  4. Relationship setup to support pivot tables connecting mutliple sheets
    By bjcsoln in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-28-2015, 09:02 AM
  5. [SOLVED] Link Pivot Tables, Filter with One Slicer
    By Pierce Quality in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-23-2013, 11:19 AM
  6. Connecting to access tables
    By dave_the_bear in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-10-2012, 04:22 AM
  7. [SOLVED] Excel Pivot tables connecting to sql
    By Justin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2006, 12:55 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