Download User`s Manual - WITS

Transcript
To cancel the output table window, click on the Cancel button located on the bottom right of the
window. Otherwise, click on Open in order to obtain the below window. Click on the Excel file in
order to open it.
B3.1.4. Understanding the Output Data
Whether you opted for View Report or Download, the output table is organized with products in
rows and sorted by the variable you chose as the first column in the Customizing the Output Data
option above.. The table below displays View Report output with China’s imports from the United
States for the year 2004 and for all 2-digit HS product codes. There are a total of “96” rows of data.
Use the vertical and horizontal scroll-bars to view all remaining rows of data and all other columns
to the right of the table.
Sorting Data
For each country table, information is sorted by descending year and trade value. You can also
sort the displayed data in ascending/descending order by clicking on the desired column heading.
For example if you click on the column heading of PartnerName once, the data will be sorted in
ascending order. In other words, the data will be sorted according to the first partner in
alphabetical order to the last. If you click twice on any column heading, the data will be sorted in
descending order.
Filtering Data
Filtering can be done according to each header, e.g. the ProductCode can be set to NoFilter,
Contains, EqualTo, GreaterThan or LessThan. Once you have chosen the specific filter, you need
48