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
Diese Übung ist Teil des Kurses
Pivot-Tabellen in Google Sheets
Anleitung zur Übung
- 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
.
Interaktive Übung zum Anfassen
Setzen Sie die Theorie mit einer unserer interaktiven Übungen in die Tat um
