• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Slicer

A

Ajith S

New Member
Hi,

I need a help.

I have three different pivot tables in three different tabs

I want to connect all these to one single slicer.

Thanks for your help.

Regards,
Ajith
 
attach a sample file which is representative of your data and we will attempt to provide you with a solution that meets your needs. Your current request is too vague to provide a viable solution as we don't have the details of your issue.
 
AlanSidman said:
attach a sample file which is representative of your data and we will attempt to provide you with a solution that meets your needs. Your current request is too vague to provide a viable solution as we don't have the details of your issue.
Click to expand...

Thank Alan for offering your help.

I have attached a sample file.

I need one slicer in Summary tab so as I select planning I can sort planning in all pivots.

Once again thanks for your help.

Regards,
Ajith
 

Attachments

  • Chandoo.xlsm
    89.2 KB · Views: 12
Hi Ajith S, so far I know slicers can only connect to different pivot tables when these share the same pivot cache. Since you are using 3 different source tables, that can't work.
Alternative, depending on your Excel version, is making a data model (powerpivot). Then it can be done. But I have not studied your data if this would be what you could use.
Seems however it can also be done via macro coding (what's new). I've found this that might help you: https://www.jkp-ads.com/articles/slicers04.asp
 
You must log in or register to reply here.
Back
Top