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