Pivot Table: Multiple row criteria from same line

[Jongo1]

Alright so tubular layout got me half way there. Each row in the data sheet has 3 vendors per item. My issue is with filtering.



[TABLE="width: 1023"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Item Number[/TD]
[TD]Vendor 1[/TD]
[TD]Vendor 2[/TD]
[TD]Vendor 3[/TD]
[TD]Sum of Sourcing[/TD]
[TD]Sum of Manufacturing[/TD]
[TD]Sum of IC/QA[/TD]
[/TR]
[TR]
[TD]Corn[/TD]
[TD]Mitchel[/TD]
[TD]Sutter[/TD]
[TD]Man[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Cheese[/TD]
[TD]Hammon[/TD]
[TD]Mitchel[/TD]
[TD]Dorn[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]4[/TD]
[/TR]
</tbody>[/TABLE]

I want to lets say filter by Mitchel and see what he supplies us. If I filter vendor 1 it will automatically exclude any Mitchel in the vendor 2 and 3 column if it isn't in the first.

 

[Jongo1]

bump

 

[Joyner]

Hello, so Pivot Table filter won’t work that way.
Why not just create a second Pivot Table by Vendor as theLeft Outer Most field?