You can rearrange the lay-out of your tables to provide the information you want in the right place. For example, the Data Source Selection you specified may default to having countries shown as the rows of your tables. But you may only have one country and several commodities and you want to have commodities in the rows instead. The technique for doing this varies depending on which Internet browser you're using.

Rearranging Rows and Columns Using Internet Explorer:

When you want to rearrange the tables using Microsoft's Internet Explorer, you can use something called "drag and drop". In the upper-left corner of your report, you’ll see header labels in gray boxes which correspond to your Selection Options. For example, in Figure A below, “Commodity,” “Time,” and “Measures” (value) are in the columns, while the “Country” dimension populates the rows. You can manipulate your table by dragging and dropping the different dimensions. This feature is especially useful if you intend to create visual media such as charts and graphs, to highlight your report findings.

Figure A: Click on the "Measures" heading and drag it over the "Time" dimension

i

Figure B: Release the "Measures" heading to successfully move the dimension

To move a header to a different location, left-click the header you want to move and drag it over the header that you want to switch places with, before finally releasing. The header being “replaced” turns yellow indicating you can release your mouse and successfully complete the process. As we see above, the Time and Measures dimensions switch from Figure A to Figure B.


Rearranging Rows and Columns Using Other Internet Browsers

Other Internet browsers don't support dragging and dropping the same way that Internet Explorer does so a different technique is provided to view rearrange the rows and columns. When you view a report using these other browsers, you'll see a pull-down box next to each dimension in the table header. The following screen shows an example using the Mozilla Firefox browser.

Figure C: Rows and Columns using Mozilla Firefox

i

Figure D: Rows and Columns using Mozilla Firefox, after swapping Country and Commodity

Figure E: Effect of changing "Row dimensions" to "2" under Mozilla Firefox:

• When moving dimensions using drag and drop, it is generally best to move from bottom to top instead of top to bottom to avoid ending up with more than one row dimension (termed "nested rows"). Depending how they are arranged, nested rows can cause problems with the sorting and rank ordering features. When moving from top to bottom though, make sure that your column variable does not end up a row variable unless you want it to.
• USA Trade Online has multiple features for organizing, manipulating, and formatting your report, including sorting, rank ordering, top/bottom reduction, and more!