+ Reply to Thread
Results 1 to 5 of 5

Slicer: Two Different Data Sources

  1. #1
    Registered User
    Join Date
    02-14-2017
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    19

    Slicer: Two Different Data Sources

    Is it possible for a slicer to filter two pivot tables simultaneously, assuming that the two pivot tables are coming from a different source (different worksheet)?

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Slicer: Two Different Data Sources

    try here: One slicer with two or more pivot tables
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Registered User
    Join Date
    02-14-2017
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    19

    Re: Slicer: Two Different Data Sources

    I'm not sure if I'm doing it correctly but wouldn't that option for slicer connection only work if it connects 2 or more pivot tables which are coming from the same table source?

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Slicer: Two Different Data Sources

    Quote Originally Posted by lb0389 View Post
    I'm not sure if I'm doing it correctly but wouldn't that option for slicer connection only work if it connects 2 or more pivot tables which are coming from the same table source?
    Soemthing like that. The same cache - the same source

  5. #5
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Slicer: Two Different Data Sources


+ 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: 4
    Last Post: 12-17-2015, 04:20 PM
  2. [SOLVED] Connect multiple pivots (with multiple data sources) to one slicer
    By jeroenft in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-24-2015, 07:29 PM
  3. [SOLVED] Connect multiple pivots (with multiple data sources) to one slicer
    By jeroenft in forum Excel General
    Replies: 1
    Last Post: 08-24-2015, 04:49 AM
  4. Make one slicer mirror filters of another slicer
    By IbenezPrez in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-28-2014, 02:00 PM
  5. Replies: 2
    Last Post: 04-15-2013, 05:33 PM
  6. Slicer Macro - unfilter another slicer on selection
    By chadheins in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2012, 10:41 AM
  7. [SOLVED] Change Chart Title Depending on a Slicer - slicer advice
    By JungleJme in forum Excel General
    Replies: 8
    Last Post: 08-17-2012, 07:59 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