TSB logo

Aggregation Option in Basic & Express...

Expand / Collapse
 

Aggregation Option in Basic & Express...


Aggregation Option (advanced option in data selection)

Background:
- Reporter countries might provide data in different quantity units.
- Utilization of ‘country groups’ feature may affect how aggregation option works when different quantity units are reported.
- Aggregation option gives the user the option on how to aggregate records given different units.
- Records with different quantity units

Example 1: No user-defined country groups

Parameters selected: With individual countries selected and no country groups defined

In the example below, quantity codes 5 (number of items) and 8 (weight in kilograms) are present (see picture below).

Note: Aggregation does not work with this selection (without user defined country or commodity groups)

Query results:

Selected classification: HS2002
Selected commodities: 8711 (Motorcycles (including mopeds) and cycles fitted with an auxiliary motor), 870310 (Vehicles (excl. of 87.02) princ. designed for the tpt. of persons, speciall ...)
Selected reporters: France, Italy, Japan
Selected years: 2004
Selected partners: USA, USA (before 1981)
Selected trade flows: Import
 




Example 2: Records with Aggregate Option 'Keep quantity unit differences' (default option)

Parameters selected:
User defined country group ‘franceitalyjapan’ is used here as an example which consists of France, Italy and Japan. User can choose to aggregate the retrieved records according to the Quantity Unit code by selecting ‘Keep Quantity Unit Differences’ option in the Express or Basic Selection.

Note: Aggregation of ‘values’ and ‘quantity’ parameters are available for the same quantity units



Query results:

Selected classification: HS2002
Selected commodities: 8711 (Motorcycles (including mopeds) and cycles fitted with an auxiliary motor), 870310 (Vehicles (excl. of 87.02) princ. designed for the tpt. of persons, speciall ...)
Selected reporters: franceitalyjapan
Selected years: 2004
Selected partners: USA, USA (before 1981)
Selected trade flows: Import




Example 3: Records with Aggregate Option, 'Ignore quantity unit differences'

Parameters selected: User defined country group ‘franceitalyjapan’ is used. User chooses to aggregate with ‘Ignore Quantity unit differences’ option selected in the ‘Advanced Items’ tab.

Note: Aggregation of values and quantities only for the same commodities. System ignores quantity units.



Query results:
Selected classification: HS2002
Selected commodities: 8711 (Motorcycles (including mopeds) and cycles fitted with an auxiliary motor), 870310 (Vehicles (excl. of 87.02) princ. designed for the tpt. of persons, speciall ...)
Selected reporters: franceitalyjapan
Selected years: 2004
Selected partners: USA, USA (before 1981)
Selected trade flows: Import







Rate this Article:

Related Links



Add Your Comments


Name: *
Email Address:
Web Address:
   
  
 
 
   
Verification Code:
*
 

Details
Last Modified:Tuesday, February 02, 2010
Last Modified By: comtrade_admin
Type: HOWTO
Article not rated yet.
Article has been viewed 12,622 times.
Options