Using 1 slicer for multiple pivots (diff data source)

Hello,

I got 2 different pivot tables from different sources and want them both to work with 1 slicer.
I don't want to combine the 2 tables to get 1 data source...

Is there an easy way to get this done? Both tables/pivots contain the same data on wich I want to filter.

Thnx in advance,

Edwin

Hi Roskame,

Welcome to the forum!

Please post the sample file & I will be able to help you.

Regards,
AM

Hey there,

thnx for welcoming me!
I been using the forum for some while now but never regestrated :P

I attached the file.
I'd like to have 1 slicer (on tab 1) which controlles both pivots.
Hope you can help me with this

Thnx in advance

Edwin

Excel forum (1).xlsx

Hi Roskame,

The two pivots you created contain different data source.
If you want to control both the pivots by 1 Slicer then the data source must be same.

I guess this will help you in better understanding.

Regards,
AM

Hey,

I already knew that ;-) but I still wanted to control them both with 1 slicer.
Must be doable with some VBA right?

ER