+ Reply to Thread
Results 1 to 2 of 2

Grouping pivot table fields under same category for slicing

  1. #1
    Registered User
    Join Date
    03-19-2014
    Location
    Burlington
    MS-Off Ver
    Excel 2010
    Posts
    1

    Grouping pivot table fields under same category for slicing

    I have a list of PivotTable fields that I want to group under a category so that I can use a slicer to filter out the relevant (or irrelevant) PivotTable fields. Right now, inserting a slicer only allows me to filter out specific instances of the fields that I seek to filter – this is not helpful. The problem is that I don’t know how to group these specific fields as one category, as I’ve tried to group those fields as different tables but this didn’t work – it just led me to the exact same problem.

    If my problem is not clear, go to the 1:04 mark of this video:

    http://www.youtube.com/watch?v=awnZjX5xt-w

    If you look at it, he’s able to bring up specific tables with headings that then make it possible to filter our relevant PivotTable fields. I want to get to that point as right now, the fields that show up are not what I seek. If I try to pick one of the fields, it only allows me to filter our specific instances of those fields and not the fields themselves (trying to be clear, hope the problem is)

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Grouping pivot table fields under same category for slicing

    the dialog you see is the one that chooses the fields that will have slicers attached. it isn't possible to have a slicer that works like a field list-they only filter the items within one field
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ 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. grouping some columns in date fields in pivot table
    By anilrini in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-27-2012, 10:15 AM
  2. Pivot Table - Grouping within the page fields.
    By ronanm in forum Excel General
    Replies: 0
    Last Post: 01-05-2011, 05:02 PM
  3. Grouping in Pivot Table with varying count of fields
    By Scotch_And_Dry in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2009, 08:11 PM
  4. Replies: 6
    Last Post: 11-28-2009, 10:35 PM
  5. [SOLVED] Pivot table grouping of dates in row fields will not work. Why?
    By Bill B in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-09-2005, 08:05 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