Select rows
In this exercise, you'll begin to populate our pivot table by selecting the Row Labels. On the right, you'll find the blank pivot table that was created in the previous exercise, containing the Top 10 companies by Revenue for 2017.
You will populate the Rows by selecting among the following categories: Name
, Headquarters
, and Industry
.
You'll start by selecting a single Row Label, then removing it, then you'll select multiple Row Labels
Cet exercice fait partie du cours
Pivot Tables in Google Sheets
Instructions
- Select Add in the pivot table editor next to the Rows section, and choose
Name
; this will list the name of each company in the dataset. - Now click the X in the upper right section of the
Name
box in the pivot table editor, this will remove the names. - Now select Add and choose
Headquarters
, select Add again, and chooseIndustry
.
Exercice interactif pratique
Passez de la théorie à la pratique avec l’un de nos exercices interactifs
