Select One Country and One Commodity Code and

  • Slides: 13
Download presentation
Select One Country and One Commodity Code, and Adding the Port Information 30/03/2012

Select One Country and One Commodity Code, and Adding the Port Information 30/03/2012

1. Click on STATISTICS, then BUILD YOUR OWN TABLES from the drop-down menu. 2.

1. Click on STATISTICS, then BUILD YOUR OWN TABLES from the drop-down menu. 2. Click on Data by Commodity Code from the left hand menu. 30/03/2012 2

You will be presented with our default table. This shows: • Both EU and

You will be presented with our default table. This shows: • Both EU and Non EU data for all four suites (Imports, Exports, Arrivals and Dispatches, • Latest 3 months data for all commodities up to HS 2 3. Click on the down arrow box next to the HS 2 box This produces a drop down menu. (Every chapter has been ticked here as it has been used to create the default table) 30/03/2012 3

4. Click on the box to the left of (Show All) to clear all

4. Click on the box to the left of (Show All) to clear all the ticks. You can now select the commodity code you are interested in In this example we are interested in commodity code 64021900 (sports footwear) If you are unsure of the commodity codes of your goods, you can find them using the ICN Online on this site. 5. Use the scroll bar to scroll down to Chapter 64 6. Click on the Expand (+) symbol to open up all the entries within Chapter 64 30/03/2012 4

7. Click on the Expand (+) symbol by 6402 to open up all the

7. Click on the Expand (+) symbol by 6402 to open up all the HS 6 headings within it 8. Click on the Expand (+) symbol by 640219 to reveal all the commodity codes (CN 8) within it… 9. … and click on the one you want (in this case 64021900 30/03/2012 5

10. When you have finished, click on OK 30/03/2012 6

10. When you have finished, click on OK 30/03/2012 6

The table shows the total trade (value) for commodity code 64021900 for all geographical

The table shows the total trade (value) for commodity code 64021900 for all geographical regions 11. Click on the down arrow next to the EU Indicator 30/03/2012 7

12. Click on the box next to the (Show All) to remove all the

12. Click on the box next to the (Show All) to remove all the ticks 13. Click on the Expand (+) symbol next to the Non EU box. 14. This opens up the geographical groupings for all non EU countries. Click on the Expand (+) symbol next to the Eastern Europe box 30/03/2012 8

15. All the countries that make up the Eastern Europe regional group are now

15. All the countries that make up the Eastern Europe regional group are now displayed. 16. Use the scroll bar to scroll down to Russia 17. Click in the box next to Russia to tick it 18. Click on OK 30/03/2012 9

19. Clicking on the Expand (+) symbol next to the Eastern Europe box… The

19. Clicking on the Expand (+) symbol next to the Eastern Europe box… The selections made are summarised in this box . . . Reveals Russia The table shows that there are no imports, only exports of sports shoes (commodity code 64021900) to Russia in 2011 30/03/2012 10

Find the Port the Export was Made From 30/03/2012

Find the Port the Export was Made From 30/03/2012

1. Hover the Port field. And keeping your finger pressed down on the left

1. Hover the Port field. And keeping your finger pressed down on the left mouse button, drag it to its new position after Country You will know when you have positioned it correctly as white “up and down” arrows will appear Port is now in position 30/03/2012 2. Click on the Expand (+) symbol next to Russia… 12

…and the Port information appears 30/03/2012 13

…and the Port information appears 30/03/2012 13

EVENT SELECT WSAEvent Select WSAEvent Select WSAEvent SelectEVENT SELECT WSAEvent Select WSAEvent Select WSAEvent Select
Advanced Select Statements Select List Variations SELECT ColumnAdvanced Select Statements Select List Variations SELECT Column
Advanced Select Statements Select List Variations SELECT ColumnAdvanced Select Statements Select List Variations SELECT Column
SELECT Query SELECT FROM SELECT DISTINCTALL columnexpression tableSELECT Query SELECT FROM SELECT DISTINCTALL columnexpression table
SELECT ROWNUM B FROM SELECT A FROM SELECTSELECT ROWNUM B FROM SELECT A FROM SELECT
Select Case if Select Case Select Case ScoreSelect Case if Select Case Select Case Score
Now continue ADVANCED SELECT FROM Select SELECT selectlistNow continue ADVANCED SELECT FROM Select SELECT selectlist
Initial Login Screen Select Carrier Select Tractor SelectInitial Login Screen Select Carrier Select Tractor Select
Select 4 n select int select int nfdsSelect 4 n select int select int nfds
Select Post Select Post Select Post lifestyle dataSelect Post Select Post Select Post lifestyle data
l SELECT SELECT FROM ORDER BY SELECT FROMl SELECT SELECT FROM ORDER BY SELECT FROM
l SELECT SELECT FROM ORDER BY SELECT FROMl SELECT SELECT FROM ORDER BY SELECT FROM