+ 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
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Slicer: Two Different Data Sources

    try here: One slicer with two or more pivot tables

  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
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    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
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    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