multiple pivots updated with selection in one table

[BorisS]

I have multiple pivots (all taking data link from the first pivot table) on
one sheet. Each sheet will have a "Salesperson" page field. I'd like to be
able to drop down the first table and select the salesperson and have all the
other tables automatically do the same.

Anyone?

 

[Ron Coderre]

Check out this tutorial link.....
http://datapigtechnologies.com/flashfiles/pivot10.html

Does that help?

 

[BorisS]

perfect. thanks so much.