I am working with pivot tables from Google Spreadsheets. It works well for me and I am extracting interesting data, basically thanks to what I learned in How do I see what is the most common value (mode) of a column? .

This time I have the following table of books read

```
A | B | C | D | E | F
año | libro | autor | nota | idioma | país autor
```

With entries of the type

```
A | B | C | D | E | F
-------------------------------------------------------------
2004 | Hamlet | Shakespeare | 8 | ES | Reino Unido
2005 | Crimen y castigo | Dostoievski | 9 | CAT | Rusia
2011 | Dersu Uzala | Arseniev | 8 | EN | Rusia
```

Now I want to create a pivot table that aggregates the countries the author comes from, tells me how many books I've read from each country, and what average grades they have.

In this specific case it would output something like:

```
país | #libros | nota media
----------------------------------
Rusia | 2 | 8,5
Reino Unido | 1 | 8
```

I have been able to do the first part, that of:

```
país | #libros
---------------------
Rusia | 2
Reino Unido | 1
```

With a pivot table where I simply choose the column `F:F`

. However, to do the mean of the grades I also need the column `D`

and I don't know how to convert `F:F`

it to something like `D:D;F:F`

. What would be the way?