+ Reply to Thread
Results 1 to 1 of 1

Pivottable: Master filter for two pivotable

  1. #1
    Registered User
    Join Date
    12-21-2012
    Location
    SaiGon
    MS-Off Ver
    Excel 2003
    Posts
    3

    Pivottable: Master filter for two pivotable

    Dear all,

    - I have sheet contain data as "DATA"

    - I have PivotTable (PVT1) from "DATA" with:
    + Filter: Year, Quater
    + Colume: Month
    + Row: Location
    + Value: Money

    - I also have PivotTable (PVT2) from "DATA" with:
    + Filter: Year, Quater
    + Colume: Location
    + Row: Month
    + Value: Money

    - I would when I select "Year", "Quater" of PVT1, Year and Quater of PVT2 is changed same

    Please help me, I have attached attached file Examples.xls

    Thanks
    Last edited by SaiDon; 12-21-2012 at 05:16 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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