Example 1: Population by country

Drag the "Country" field to the row region and the "People" field to the data region, then move the measures field that is already located in the filters region into the columns region:

These steps give the grid below:

It is easy to see that the data in the grid is incorrect. The reason for this is that here the "People" measure sums the values for all years. So we need to specify the required year. To do this, we must drag the "Year" field into the filters region.

When a field is added to the filters region of the grid, an element appears to enable data filtering through a drop-down list.

Let's click on the drop-down list of the "Year" field:

As shown, the grid contains data for 11 years. But we only need the data for 2006 - this can be achieved in several ways:

  1. by un-checking every year not needed, one by one (i.e. from 1996 to 2005)
  2. by un-checking just 2006 and then clicking the "Inverse" button
  3. by clicking the "Clear all" button and then clicking on 2006
  4. by clicking on 2006 while holding down the 'Ctrl' key on the keyboard

After these changes to the "Year" dimension the grid looks like this:

Note that the title 'Year' is displayed in italic and the drop-down icon shows a funnel, which means that a filter is applied to it.

Also note that the values of the "Country" dimension are listed in the alphabetical order/. For our analysis it would be more useful to list the countries in descending order of population. To do this, we need to sort the data by the value of the measure.

Click on any data cell in the grid, in the column which will be used for sorting the data, and select the option "Sort by focused column" in the toolbar:

This results in the grid displaying the data sorted by the value of the "People" measure (population), but in ascending order. Note that the column used for the sort is marked with a special symbol (diamond):

To change the sort order to descending, double-click on the "Country" dimension (or do the same on the drop-down dimension menu).

Adding Percentage and Rank columns to the measure values, shows that China takes the first place by population (20% of the total population) and the United States only takes third place (4% of the total population).