Results 1 to 2 of 2

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

Threaded View

  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

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