Aggregation Option (advanced option in data selection)

Background:
- Reporter countries might provide data in different quantity units.
- Utilization of the ‘country groups’ feature may affect how the 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 chosen countries 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, special ...)
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. According to the Quantity Unit code, users can choose to aggregate the retrieved records by selecting the '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, special ...)
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. The user chooses to aggregate with the ‘Ignore Quantity unit differences’ option selected in the ‘Advanced Items’ tab.

Note: Aggregation of values and quantities only for the same commodities. The 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, special ...)
Selected reporters: franceitalyjapan
Selected years: 2004
Selected partners: USA, USA (before 1981)
Selected trade flows: Import




Similar Pages: