Pivot Table - One Part Shipped to Many Locations

mwooten777

New Member
Joined
Feb 23, 2012
Messages
12
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
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,129,795
Messages
5,638,370
Members
417,023
Latest member
Zimbo38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top