How do I make pivottable filters filter each other?

[InactiveB1650B]

I'm using excel 2010. When I try to filter a pivotTable, the other filters won't narrow themselves down the way they do with just data. Is there a property in VBA I can use to fix this?

for example:

"Report Filters" are buyer and vendor

-March 1
--order1 (buyer = matt, vendor = bob)
--order2 (buyer = matt, vendor = bob)
-April 1
--order3 (buyer = dave, vendor = ted)
--order4 (buyer = dave, vendor = ted)

when i set the filter on buyer to matt, I don't want the drop-down for vendor to still have ted in it, or the drop-down for date to still have April 1 in it, etc

Thanks!
-Matt

 

[Andrew Poulsom]

Sorry, there isn't a setting to make the report filters dependent. But slicers behave in a way that's similar to what you want.

http://blog.contextures.com/archive...ers-for-halloween-horror-films/#axzz1S57liQxJ