Pivot Table Link Help

[akers77]

Hi,


I’m trying to link multiple pivot tables to one filter. On the file attached, three pivot tables (second tab) are filtered based on Company and Unit. If possible, I’d like to link all filters to the first filter (i.e. if I select Company Rocky and Unit 1, the other two pivot table will automatically set these filters).


Does anyone know how this can be done?


Also, If I add additional information to a data set that is linked to a pivot table, will it automatically be updated?


Thanks for the help! :)


-Andy

[Bob Phillips]

Haven't you asked this somewhere else?