PDA

View Full Version : Help with setup of pivot table



jdrockefeller
2017-01-25, 03:35 PM
Hello again everyone!

I was wondering if someone could help me with a problem i have.

I work for a company that sells commodities (for this case i jsut need help with coffee), I have a sheet with our internal countries of origins and destinations along with the amount (in tons) that we send.

I also have a sheet with the global data of origins and destinations along with the amount in tons as well.

I'm trying to set up a comparison chart to see where we are strong, where we are weak and where we are missing untapped opportunities.

Thank you very much in advanced for the help!

p45cal
2017-01-28, 12:46 AM
cross posted without links and solved:
http://www.excelforum.com/showthread.php?t=1171269&highlight=
jdrockefeller, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184