• 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.

connecting 5 pivot tables

D

dgavilanes

Member
Hi All,


How do I go about connecting 5 pivot tables driven by the same unique indicator, the file format is for excel 2007 so slicers could not be used in this case.


Any suggestions would be greatly appreciated!!


Regards,


Dennis
 
Dennis


Instead of connecting your data directly to the Data connect it to a filtered set of data which has been filtered by your Unique Indicator.

You could use an Advanced Filter or Formula to derive the filtered data
 
Hi Hui,


Thanks for your quick reply, assuming I'm able to connect them, the information generated is syncronized to a template and this excel file is going to be send out; so it will be a click annd go situation.


Regards,,


Dennis
 
I found a video that shows step by step on how to Synchronize 2 Pivot Tables with a Combo Box for an earlier version.


Here is the link so if it can help somebody else.


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


Regards,,


Dennis
 
You must log in or register to reply here.
Back
Top