How to join filter with two pivot tables with same data source-NOT SLICER

[KiKi]

I want to join two pivot tables(containing different data) with same filter of date. I am aware i can connect slicer with two PTs, but i want to do it from filter not slicer. Any advice will be helpful.

 

[Asheesh]

Hi Kiki,

See the below link

http://www.datapigtechnologies.com/flashfiles/pivot10.html

 

[KiKi]

Hi Kiki,

See the below link

http://www.datapigtechnologies.com/flashfiles/pivot10.html

I think this is not excel 2010... i work on 2010

 

[Chihiro]

The link should still be applicable to 2010. Interface will be little different, but concept remains same.

 

[NARAYANK991]

Hi ,

If you use VBA , this is simple. See this link for details :

https://books.google.co.in/books?id...wo pivot tables controlled one filter&f=false

or , the shortened link is :

http://bit.ly/1JiHi03

Narayan

 

[jeffreyweir]

...and then there's my way that uses a hidden slicer and a copy of the PivotTable masquerading as a dropdown:
http://dailydoseofexcel.com/archives/2014/08/16/sync-pivots-from-dropdown/