FOREIGN TRADE QSC

How to Download, Format, and Calculate Totals

Steps

1. To run a report select your desired parameters. First, select the type of trade that you would like to query. Next select the years. To select multiple years, hold down the ctrl key while clicking on the desired years or click-and-drag for subsequent years.

2. Click the single arrow pointing right to add it to your query. If you accidentally select a year that you do not want to query, simply select it and click the arrow pointing to the left.

You can also select all years by clicking the double arrow pointing right.

3. Choose what geographic scale you would like to query: Continents, Country or US Customs District.

4. Select the geographic scale that you would like to query. Hold down the ctrl key or click-and-drag to select multiple scales simultaneously.

5. Click the single arrow pointing right to add it to your query. If you accidentally select a geographic scale that you do not want to query, simply select it and click the arrow pointing to the left.

You can also select all geographic scales by clicking the double arrow pointing to the right.

6. Select the product type you would like to query. Hold down the ctrl key to select multiple product types simultaneously.

To find the product type type more quickly, you can use the "Search Products" option to quickly narrow down the options. For example, by typing "tuna" and hitting "search," you can see the product type field is narrowed to just tuna product type.

7. Click the single arrow pointing to the right to add it to your query.

You can also select all product type by clicking the double arrow pointing right

8. Click the RUN REPORT button.

9. The results will appear on the right side of the page by year, product name, country name, trade type, volume, and value.

From there, you can view the data in different ways by selecting from the drop-down menu found directly above the results.

10. To start over or create a new query, select the Reset button.

How to Download, Format, and Calculate Totals

Report Download

To download a Foreign Trade report:

Click on the Format & Download dropdown button.
Click Download
Choose a format to download the report.

Chart

To create a chart or graph of the Foreign Trade data:

Click on the Format & Download dropdown button.
Click Format
Click Chart
Select a Chart Type.
Select a column in the Label dropdown.
Select a column in the Value dropdown.
Select a mathematical function in the Function dropdown.
Enter a title name in the Axis Title for Label field.
Enter a title name in the Axis Title for Value field.
Click the Apply button.

Highlight

To highlight specific information in the Foreign Trade report:

Click on the Format & Download dropdown button.
Click Format
Click Highlight
Select a Highlight Type. You can choose to highlight an entire row or a single cell where the condition is applicable.
In the Highlight box, select a background color. This will be the color of the highlight.
Choose which information to highlight in the Highlight Condition section by selecting an option from the Column, Operator, and Expression dropdowns.
Click the Apply button.

Calculate

To calculate specific information in the Foreign Trade report:

Click on the Format & Download dropdown button.
Click Format
Click Group By
Select a column in the Select Group By Column dropdown.
Select a function in the Functions dropdown.
Select a column in the Column dropdown.
Click the Apply button.

Additional Information

Foreign Trade Data Restrictions

Some caveats with the Foreign Trade data:

IMPORTANT: ENTER FOREIGN TRADE CAVEATS HERE

IMPORTANT: ENTER FOREIGN TRADE CAVEATS HERE 2

User Feedback

Let us know what you think.

We are looking for user feedback on this query tool as we continue to fine-tune it and add new features.

Please navigate to the comments tab to submit a brief comment.

Header

FOREIGN TRADE QUICK START GUIDE