Google Sheets Course: Pivot Table

The pivot table allows you to summarize the data from a database so as to obtain the desired data combination (for example, the turnover generated by employee).

This introduction to pivot tables aims to show you a simple example of a pivot table to better understand its utility and see the potential of this feature.

The (very small) database of this example is as follows: lesson-10c.xlsx

To add a pivot table, select the database (with headers) and click on "Pivot table" in the Insert menu:

Insert the pivot table into a new sheet:

The pivot table has been created.

Now you need to enter in the pivot table editor (on the right) what data to display and how:

The goal here is to obtain a table that groups each fruit by origin and displays the total number of units purchased and the average price per unit.

Start by adding the "Product" row:

Then add a second row "Origin":

Adding these first 2 rows already gives a first result (the fruits and the existing origins for each fruit):

Then add a first value "Number of units purchased":

Then the value "Price per unit":

The price per unit should be here an average and not a sum, so you need to change the function:

After renaming cells C1 and B1, the pivot table is now finished and displays the expected data:

Explore

The Explore panel also allows you to create simple pivot tables:

If one of the suggested pivot tables suits you (knowing that you can then modify it like any other pivot table), you can add your pivot table from this panel to save time.