This section illustrates the impacts of placing fields in row and column in cross tab on data query.
Case I: Placing field in row.
Suppose the user wants to query a data for emissions from energy sector by Party, by Gas and by Year,
the following fields should be placed in the cross tab (if it is not there already) by row. This can
be done by clicking on the left arrows of Party, Gas and Year buttons and this is how the layout will
Note that the orientation of the directional arrow changes once it is placed in the cross tab. The
horizontal arrow allows the user to move the position of selected field laterally and the
vertical arrow allows moving the fields back into the page item.
For example, the user chooses to access data for CO2 and CH4 emissions from
Energy Sector of two Parties for two years. The user would then choose CO2 and
CH4 from the Gas dropdown list, any two Parties and any two years depending on the
user's interest of query. Accordingly, the data would be displayed as illustrated.
Case II: Placing field in column
If the user wants to conduct a query for the same information as in Case I but with "Gas"
field as column then the layout would look as follows:
And accordingly the data layout is also changed.