+ Reply to Thread
Results 1 to 4 of 4

Pivot Table Slicer function

  1. #1
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Pivot Table Slicer function

    What's the difference between a slicer and just putting a field into the Report Filter catagory? Is there anything you can do with one that you can't do with the other? Or is there a situation where you'd use one and not the other?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Pivot Table Slicer function

    hi ChemistB. a few i could think of are:
    1. you save at least two clicks. with the report filter, you need to click the dropdown and deselect all first before you choose any of them
    2. it is good for newbies/bosses who don't know how to use it. a slicer is much more straightforward
    3. you can connect multiple pivots with a single slicer (my favourite use of it). that makes it a very simple dashboard to make. imagine selecting a period like Aug 2015 and all 10 of your pivot charts change together. =D

    edit: and to add to point 3 if you have never used it; you just have to create slicer(s) for one pivot and then copy the pivot and the slicer connection will follow. you can also choose to not connect the slicer of course. that is by clicking on the pivot table and then go to Options -> Insert Slicer -> Slicer Connections
    Last edited by benishiryo; 09-25-2015 at 09:16 PM.

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

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

    Re: Pivot Table Slicer function

    Also, with a slicer it's much easier to see what the filters in use are when more than one value has been selected.
    Remember what the dormouse said
    Feed your head

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Pivot Table Slicer function

    Thank you guys. I will play with using the slicer for multiple tables.

+ 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. Limiting a pivot table slicer to one selection
    By behrensf84 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2014, 09:25 PM
  2. Pivot Table Slicer Problem
    By skate1991 in forum Excel General
    Replies: 2
    Last Post: 02-28-2014, 09:54 AM
  3. Slicer Not Recognizing Pivot Table
    By BigBadBill in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2013, 12:22 PM
  4. [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
  5. Pivot Table (Slicer) Help
    By skate1991 in forum Excel General
    Replies: 0
    Last Post: 10-11-2012, 11:52 AM
  6. Disconnect a pivot table from a slicer
    By LisaK in forum Excel General
    Replies: 5
    Last Post: 04-12-2012, 11:07 AM
  7. Pivot Table Slicer Limit?
    By zlehmann in forum Excel General
    Replies: 0
    Last Post: 11-21-2011, 12:35 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