Help with setup of pivot table

[JDRockefeller]

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!

 

[cchavez24]

Here is a start to that problem.
I would use these headers for your columns

Orgin
Destination
Quantity (tons)
Shipping Costs
Terrifs

Then in the rows put as many historical orders as you wish. This will give you a very good overview for strenghts/weaknesses.

Hope this helps.
Let me know if you have any questions.

PS Later you can also look at currency gain/loss.