UTO Help: View Report Set Dimension Order

USA Trade®
Online

Other:

Manual:

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. There are two ways to rerrange table report rows and coloums: "drag and drop" and "set dimension order". In this section, you'll learn how to utilize the set dimension order.

Set Dimension Order
Faster and more precise than drag and drop, you can get started by clicking the icon on your report toolbar. That will open up the set dimension order dialog box shown in Figure A.

Figure A: Set Dimension Order Dialog Box

Set dimension order dialogue box

There are three areas in which you can position the dimensions of your report. They're pretty obvious until you hit "OTHER":

Rows go down the left side of your report.
Columns go across your report.
Title end up in the titles of your report. This will be explained shortly.

The various icons move dimensions from one area to another and determine their sequence within an area:

Use the left and right arrow buttons to move a single dimension between the Rows, Columns, and Title dimension areas.
Use the double arrow buttons to move all the dimensions out of a dimension area at once.
Use the "move to top," "move up," "move down," and "move to bottom" arrow buttons to nest dimensions in the desired order.

The "Title" dimension determines how many individual tables you'll see in your results. If you're used to spreadsheets, think of "Title" as determining how many sheets you get within a given spreadsheet. You'll end up with a separate table for each combination of items that appear in your results. In Figure B below, Commodity is in the "Title" dimension. If there are five commodities in your report, you'll end up with five separate tables -- one for each commodity.

Figure B: The "Title" Dimension

The "Other" Option for Set Dimension Order

The "Title" dimension area appears at the top of the dimension area, just below the pagination area. It is shown in the same color as the row dimensions. "Title" dimensions do not appear on the rows or columns of a report, but the data from the active members of the "Title" dimensions are included in the report's values. Any dimensions can be placed there, as long as the report still contains at least one row dimension and one column dimension.

Helpful Hints and Related Information

When moving dimensions, keep a watch out for nested rows. These are cases when two dimensions are used in the row section. Depending how they are arranged, nested rows can cause problems with the sorting and rank ordering features.
In general, if there is only one item in a dimension (for example, Measures just has Value selected), moving that dimension into the "Title" area will make the table cleaner.
USA Trade Online has multiple features for organizing, manipulating, and formatting your report, including sorting, rank ordering, top/bottom reduction, and more!