+ Reply to Thread
Results 1 to 3 of 3

Possible to use slicer to filter data from multiple columns in a pivot table?

  1. #1
    Registered User
    Join Date
    08-11-2010
    Location
    Miami, FL
    MS-Off Ver
    Excel 2003
    Posts
    10

    Question Possible to use slicer to filter data from multiple columns in a pivot table?

    Hello,

    I have a pivot table that I've applied slicers to. Three of the columns include identical drop lists. Any one of the items from the drop list may be in any of the three columns. Is it possible to make a slicer or equivalent way of presenting the data to include all instances of one of the drop list items?

    Let's say I have:

    2012 January AAA test1 test2 test3
    2013 February BBB test2
    2013 March AAA test2 test3

    and I have a slicer and choose test2. I want it to include the 3 instances. I like the ease of use of slicers. Is there a way to do that with a slicer and if not, what is the best way to do it?

    Any help would be appreciated. Thanks.

    Robert

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,134

    Re: Possible to use slicer to filter data from multiple columns in a pivot table?

    Hi,

    Can you please post a sample template of your workbook using "Go Advanced" option? You may choose to delete the confidential data in the file before upload, if any.

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

    Re: Possible to use slicer to filter data from multiple columns in a pivot table?

    No you can't do that with a slicer, unless you change your source data so that those entries are all in one field.
    Remember what the dormouse said
    Feed your head

+ 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. Updating a pivot filter with another pivot updated by a Slicer
    By Jabba69 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-17-2014, 04:08 PM
  2. [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
  3. [SOLVED] Use slicer selections on one pivot table to filter another pivot table
    By porkandbeans in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2013, 12:30 AM
  4. [SOLVED] Pivot Slicers from multiple Caches - problem with 2nd Slicer displaying incorrect data
    By matt4003 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-14-2013, 03:06 AM
  5. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM

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