+ Reply to Thread
Results 1 to 2 of 2

Two pivot tables with the filter of pivot table 2 to automatically update to filter 1

  1. #1
    Registered User
    Join Date
    10-31-2016
    Location
    Melbourne
    MS-Off Ver
    13
    Posts
    33

    Two pivot tables with the filter of pivot table 2 to automatically update to filter 1

    Dear all

    I have two tabs with 2 pivot tables (1= Customer Analysis, 2= Product Analysis). In pivot 1, I want to choose the customer name in a filter; this customer name should automatically be pulled by pivot table 2 as well. How to do it? Please see attached "Tool" for my data.

    Thanks and many kind regards
    Attached Files Attached Files

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Two pivot tables with the filter of pivot table 2 to automatically update to filter 1

    You can do this with a slicer if both your pivots have the same pivot cache (which it currently appears that they don't).

    See the attached example where I've created a second pivot table with the same pivot cache.
    Attached Files Attached Files

+ 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. Two pivot tables with the filter of pivot table 2 to automatically update to filter 1
    By StefaniaLa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2018, 06:19 PM
  2. Replies: 2
    Last Post: 12-18-2016, 08:37 PM
  3. [SOLVED] How to get pivot table filter options to update?
    By Slurry Pumper in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-12-2016, 08:45 AM
  4. Automatically update pivot report filter
    By carlwin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2015, 07:57 PM
  5. Update Filter several Pivot Table by day
    By l.niehues in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2014, 10:04 AM
  6. Update pivot tables based on source data filter
    By papasmurfuo9 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2014, 08:03 AM
  7. Pivot table Filter update through VBA code
    By way2suresh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-01-2013, 08:48 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