Results 1 to 7 of 7

use a single report filter for multiple pivot tables

Threaded View

  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    TN
    Posts
    2

    use a single report filter for multiple pivot tables

    Lets say I have four seperate pivot tables. Lets say the pivot table area all pulling from a single source of data that contains the following data. (I am just making up something simple for our purposes)

    Car Brand
    Number Sold
    Defects Encountered
    Positive Reports
    Negative Reports
    Etc.

    So lets say on sheet 1 I want a PIVOT table that gives me the total number sold and percentage of such whatever. The point is the report field should be car brand.

    Now lets say pivot table number two is to show the number of positive and negative reports, again with car brand being the report filter.

    What I want to be able to do is simply choose car brand as a report filter a single time on sheet 1 and have it carry over to my subsequent sheets/pivots.

    Is this possible?

    Thanks
    Chris
    Last edited by VBA Noob; 02-03-2009 at 03:02 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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