Pivot Table - One Part Shipped to Many Locations

[mwooten777]

We ship parts to multiple locations. I'm trying to see parts by a specific location (easy), and at the same time see the other locations a specific part ships to. So far all my efforts have been self-defeating because of the initial filtering by location. An easy example:

Part Number Location Sales
123 Decatur 25
123 Salem 44
456 Decatur 34
789 Salem 41

It's easy to filter the parts by location:

Decatur
123
456

But I want to see something like this:

Decatur (Location I'm initially filtering by)
123 (part number)
Salem (additional locations the part ships to - not a problem for my analysis if it also includes Decatur)

So that when I look at the parts that ship to Decatur, I can also the other locations a specific part ships to.
The difficulty is the initial filtering by Decatur keeps any other locations from showing up.

I would greatly appreciate any help in solving this dilemma!

Thanks,
Mark

 

[mwooten777]

Hi, folks. Any ideas on this one - it's a head scratcher!