how do i narrow down the items in a pivot table drop down list?

[bac9999]

I have business groups in one column and products for those business units in
another column (with associated data in subsequent columns). When i create a
pivot table and then select one particular business unit, on the drop down
for the products i only want to see the products that relate to that business
unit. Right now i still see all of the products and it is a big list with
lots of different products. Is there a way to narrow down the drop down list
when a higher order drop down in selected?

 

[Barb Reinhardt]

Click in the down arrow for the Business Unit and you can select which
business unit you want.