Customizing Output Tables - Introduction

WITS gives you a result screen by default: information corresponding to your query definition is displayed as a unique table following ordering rules we described previously. Depending on your query and your needs, this data organization may not be the most efficient. The output table can be customized with a lot of flexibility.

To customize an Advanced Query output table:

1. Click on the Back button if you are already on the results screen;
2. On the column selection screen you can select the columns from left Available Columns and press the > to move the selection to the right Selected Columns. Use the >> button to move all the columns to the Selected Columns section.
2. To remove a selected column(s) select the column(s) in Selected Columns and press the <. Note some columns (like Partner Code, Product Code, Reporter Code) are mandatory and cannot be removed.

You can use the Up and Down button to order your column selection in the Selected Columns section. To sort the data by a particular column ensure the column is first in the Selected Columns section. On selecting a column name you also get a brief description of the column below the Pivot Header drop down.

Next: Pivoting a table

---

WITS Online Help

The World Bank, 2010