+ Reply to Thread
Results 1 to 2 of 2

Custom filter on slicers

  1. #1
    Registered User
    Join Date
    05-31-2017
    Location
    perth
    MS-Off Ver
    2013
    Posts
    21

    Custom filter on slicers

    Hi All,

    Just wondering if its possible to have a number of slicers attached to a pivot table but have certain slicer buttons perform a custom filter each time its selected.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,807

    Re: Custom filter on slicers

    Without a sample workbook, I can only offer general advice. You probably need helper columns in the source data that evaluate to true or false for whatever custom filter you want.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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: 6
    Last Post: 09-23-2020, 02:02 AM
  2. Filter Invoice Table with Slicers
    By bj90 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 08-05-2019, 11:03 AM
  3. [SOLVED] one slicers to filter data
    By hudson andrew in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-23-2018, 01:27 PM
  4. [SOLVED] VBA to Auto Filter Slicers
    By bgrish3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-09-2016, 10:40 AM
  5. Timeline to filter with Slicers
    By PFDave in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-23-2016, 10:25 AM
  6. slicers vs. filter
    By stephme55 in forum Excel General
    Replies: 1
    Last Post: 02-08-2016, 07:36 PM
  7. [SOLVED] Custom Styled Slicers not Available in New File
    By Melvinrobb in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-14-2013, 12:30 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