You can make a Pivot Table in Google Sheets to simplify analysis of complex data. A Pivot Table allows you to compare values and also see trends and patters.
In this guide you will learn how to make a Pivot Table in Google Sheets.
How to Make a Pivot Table in Google Sheets
The Google Sheets table below shows sales divisions of a company, the subdivisions and information about products.
The table has a number of uncategorized data like multiple sales Divisions and Subdivisions. It also has information regarding the number of products and prices per unit.
In this example, I will show how to make a Pivot Table to sort the data by Divisions and Subdivisions. The Pivot Table will also show total number of products and Average price per unit.
To make a Pivot Table in Google Sheets, follow the steps below:
- Select the data you want to plot a Pivot Table for, including the table headers.
- Next, click Data tab.
- Then click Pivot Table. The Create pivot table option will open.
- To create a Pivot Table, click Create. This will create a blank Pivot Table as shown in the image below.
How to Add Data to a Pivot Table in Google Sheets
Once you have created a blank Pivot Table, you need to add data to the Pivot Table.
Here are the steps:
- Beside Row, click Add. Then select Divisions. Click Add again and select Subdivisions. This will add both to the Pivot Table.
- Next, beside Value As, click Add. Then select Number of units. Click Add again and select price per unit.
- To change SUM of price per unit column to average, on the price per unit section click the Summarise by drop-down. Then select AVERAGE. Leave the Show as drop-down as Default.
How to Filter Data in a Pivot Table in Google Sheets
After making a Pivot Table in Google Sheets, you may want to add some filters.
To filter the above Pivot Table by Division, follow the steps below:
- Beside Filters, click Add. Then select Division.
- The default Filter Status is Showing All items. To show only East Division, click the Status drop-down. You can filter by condition or by values. The Filter by values is expanded by default.
- To show only values in the East Division click West to uncheck it. Then click Ok. The Pivot Table is now only showing values from East Division.
To see the filter by condition options:
- Click the Status drop-down option. Then expand Filter by condition.
- To see available filter options, click the None drop-down.
Pivot Table gives you the ability to organize large data to enable you easily analyze the data. This guide demonstrated how to make Pivot Table in Google Sheets. I hope it was helpful.
Have questions or comments? Use the “Leave a Reply” form at the end of this page.