+ Reply to Thread
Results 1 to 2 of 2

Filter pivot with slicer for each column

  1. #1
    Forum Contributor
    Join Date
    10-26-2013
    Location
    Athens, Greece
    MS-Off Ver
    Excel 2013
    Posts
    248

    Filter pivot with slicer for each column

    Hi. When I use the slicer and select a field all columns of a pivot change. I would like to use slicer in a pivot and filter only in 1 column and the other columns to stay the same. How can I do that?

    Thank you

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Filter pivot with slicer for each column

    Hi,

    A slicer filters one field only. If filtering that field affects other columns in your pivot table there really isn't anything you can do about that. It might help if you gave a specific example of what you are talking about- then someone could perhaps come up with an alternative solution.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. Filter a 2nd pivot with the inverse of a slicer
    By spikey_plant in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-27-2015, 12:55 PM
  2. Change Pivot Table Column field on Slicer selection (Excel 2013)
    By kevboyo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-27-2014, 11:36 PM
  3. Replies: 2
    Last Post: 07-30-2014, 05:50 AM
  4. 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
  5. [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
  6. Replies: 1
    Last Post: 06-20-2013, 05:51 PM
  7. [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

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