Selection in one pivot table object should not be reflected in another pivot table object in same sheet
I have a application where are two pivot table charts and some calender selection objects are there like Year, Month, Quarter, Current Week, Yesterday, Sales manager, Manager. I have a query that if i select some calender selection like Year, Month, Current Week, Yesterday, Quarter then it will reflect only single pivot table and data should change according to data but another pivot table chart will unchange when i select Year, Month, Quarter, Current Week, Yesterday. Also when i select Sales manager, Manager it will change. Please provide help for that.