Google Sheets

How to Create a Pivot Table in Google Sheets

How to Create a Pivot Table in Google Sheets

A pivot table is a data summarization tool that allows you to quickly and easily create a summary of large data sets. It does this by allowing you to "pivot" or change the way the data is displayed. For example, you can create a pivot table that summarizes how much money each customer has spent on your products, or how many sales each salesperson has made.

To create a pivot table in Google Sheets, you first need to have some data to work with. The data can be in a spreadsheet, or it can be in a table on a web page. Once you have the data, follow these steps:

1. Open Google Sheets and create a new spreadsheet.

2. Click on the data you want to use for your pivot table.

3. Select "Data" > "Pivot Table" from the menu bar.

4. The "Pivot Table" dialog box will open. In the "Table Name" field, enter a name for your pivot table.

5. Click in the "Create a pivot table based on this data" field.

6. The "Pivot Table Field List" will open. This is where you select the fields you want to include in your pivot table.

7. Drag the fields you want to include in your pivot table to the "Area" column.

8. Click "OK" to create your pivot table.

9. The "Pivot Table" will open. The fields you selected will be in the "Columns" and "Rows" sections.

10. To change the way the data is displayed, drag the fields to different sections.

11. To filter the data, click the filter icon next to the field you want to filter.

12. To sort the data, click the sort icon next to the field you want to sort.

13. To change the summary calculation, click the gear icon next to the field you want to change.

14. To hide a field, click the hide icon next to the field you want to hide.

15. To print the pivot table, click the print icon.

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.