Grouping and pivoting is your next step in learning to skillfully aggregate data. Albeit a small difference in the outputted layout of each (don't worry, we'll explain), both will enable you to aggregate data by variables of your choosing.
We'll introduce the Pivot Table feature in Google Sheets, which is one of the most widely used features in spreadsheet software.
Database and SQL
The SQL operators introduced in this lesson include:
- GROUP BY
This lesson will introduce the Pivot feature in Looker.