When I select an item to be reported on a pivot table via a drop down list, is there a way to restrict the data values in other columns to only those available to the first item selected?

Example. 2 warehouses. Each stores 50 unique products; i.e., 100 different products in the company. Each product is stored in one warehouse only. When I select the first warehouse via a pivot table, the drop down list for the product column shows all 100 products. I want the drop down to show only the products in the warehouse selected. Can that be done?

Thanks.