+ Reply to Thread
Results 1 to 4 of 4

Filter pivot items using pivot items from another table

  1. #1
    Registered User
    Join Date
    09-12-2012
    Location
    gemestio are
    MS-Off Ver
    Excel 2010
    Posts
    53

    Filter pivot items using pivot items from another table

    Hi -

    Is there a way to filter the pivot items of a pivot table based on the pivot items in another pivot table? I tried the following code but no success:

    Please Login or Register  to view this content.
    Please help.

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Filter pivot items using pivot items from another table

    Since you are using Excel 2010...You have SLICERS!
    Select a cell in one of your pivot table
    From the PivotTableTools tab on the ribbon
    ...Analyze.Insert Slicer...Select the field(s) you want to filter on...Click: OK
    ...Right-click on the Slicer...Report Connections...Check the pivot tables you want to control from your slicer.

    Changes to Slicer filters will impact all connected pivot tables.

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    09-12-2012
    Location
    gemestio are
    MS-Off Ver
    Excel 2010
    Posts
    53

    Re: Filter pivot items using pivot items from another table

    Thanks for the reply. It would work if i can automatically filter the slicer, otherwise it brings me back to where i started from, unless I am missing something?

  4. #4
    Registered User
    Join Date
    09-12-2012
    Location
    gemestio are
    MS-Off Ver
    Excel 2010
    Posts
    53

    Re: Filter pivot items using pivot items from another table

    Basically the first pivot table will get updated based on a VBA code and I want to use its pivot items to automatically update the second pivot table.

+ 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. Pivot Table - can't filter items in page area
    By seyss in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-01-2013, 11:33 AM
  2. Macro that would filter pivot table top 10 items
    By weecha in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2013, 01:28 PM
  3. 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
  4. Rename items in report filter in Pivot table
    By jenzz22 in forum Excel General
    Replies: 1
    Last Post: 03-07-2012, 02:36 PM
  5. Select and unselect items in a filter in pivot table
    By TPFKAS in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2010, 09:39 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