+ Reply to Thread
Results 1 to 6 of 6

Make one slicer mirror filters of another slicer

  1. #1
    Registered User
    Join Date
    07-20-2012
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010
    Posts
    10

    Make one slicer mirror filters of another slicer

    I' have two slicers that each control two pivot tables. The slicers both are for the same field ("Department") but I guess the pivot table structure differences don't allow me to simply have one control all four tables.

    Since both slicers contain the exact same options from the same field on the same origin table, I would like to problematically ensure that when department "A" is selected on slicer1, it is also selected on slicer2. When departments "A, B, & C" are selected on slicer1, the same are selected on slicer2. When filters are cleared... you get the picture.

    Searched all afternoon yesterday with no luck. Anyone able to point me in the right direction? Thanks in advance!

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Make one slicer mirror filters of another slicer

    I assume you mean programatically, not problematically....I thought it was funny...can you upload a file with no company confidential stuff....I'm getting into slicers heavily so I "might" be able to help....I still have a lot to learn but I'd like to try....if you can upload the data....HTH....
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    07-20-2012
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Make one slicer mirror filters of another slicer

    Aaaaand, I'm an idiot. I must have originally created two slicers for the two sets of pivot tables, generating two separate pivot caches that could not be linked. As soon as I deleted both, and created a new one I was able to link it to all 4 tables. My apologies. Thanks for the attempted assist though

    Ha! Some typos are more correct than the original text, eh?

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Make one slicer mirror filters of another slicer

    I was curious about how your dataset was connected.....always fun to figure it out on your own....have a great day

  5. #5
    Registered User
    Join Date
    07-20-2012
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Make one slicer mirror filters of another slicer

    False positive. It APPEARED to resolve my problem. I can have the slicer control either of the two pairs of pivot tables, but not both at the same time. Back to trouble.

    Replacing the sensitive data in this document is a task in and of itself, so I may have to try tonight. Thanks and sorry for the confusion.

  6. #6
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Make one slicer mirror filters of another slicer

    boy, I know that feeling....no problem at all....thanks for the heads up....besides, you already gave me the rep points....I have to try something....

+ 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: 03-08-2013, 06:34 AM
  2. 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
  3. Selecting Slicer filters from a cell/cells
    By Grizz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-04-2012, 03:07 PM
  4. [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
  5. How to make slicer sort dates correctly?
    By Elias Hedberg in forum Excel General
    Replies: 1
    Last Post: 08-04-2011, 10:26 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