Pivot Table linkage

[boxsterman]

Hi,

I have lists of sales data, some based on sales dollars some based on total units... They all roll up to individual Sales Reps. I have signified the sales rep list to be the driving factor for the page. I.e. to only show one at a time (based on user input).

Is it possible to have another pivot table (which is based on that pivot table) to change its sales rep when the first on changes?

Thanks.