How to Make a Pivot Table in Google Sheets

-

|

Introduction

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.

How to Make a Pivot Table in Google Sheets - raw data
Advertisement

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.
How to Make a Pivot Table in Google Sheets - select the data including column 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.
How to Add Data to a Pivot Table in Google Sheets - add rows
  • Next, beside Value As, click Add. Then select Number of units. Click Add again and select price per unit.
By default Google sheets computes Value As, as SUM. But I want the last column, SUM of price per unit be be calculated as Average instead.
  • 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.
When you change the Value as column, Google sheets automatically renames the column label it as AVERAGE of price per unit.

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.
 How to Filter Data in a Pivot Table in Google Sheets
  • 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.
 How to Filter Data in a Pivot Table in Google Sheets
Advertisement
  • 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.
As I pointed out earlier, you can also filter by condition. Pivot Table in Google Sheets provides a number of condition filters.

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.

Conclusion

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.

Other Helpful Guides

Additional Resources and References

LEAVE A REPLY

Please enter your comment!
Please enter your name here

FEATURED POSTS

network discovery keeps turning off server 2016

How to Fix Network Discovery If it Keeps Turning Off in Server 2016

Does network discovery keep turning off in your Windows server 2016? It is likely that one of its dependent services is not...
how to install windows 10 1903 update manually

How to Install Windows 10 1903 Update Manually

Windows 10 1903 Update was released in May, 2019. But some users are not yet offered the update via automatic update. The...
spotify web player not working

Spotify Web Player Not Working [Fixed]

Introduction Spotify Web Player may stop working for you with the following error messages: "Spotify Web Player an Error...
DISM.exe /Online /Cleanup-Image /Restorehealth

DISM.exe /Online /Cleanup-Image /Restorehealth Explained

What is DISM.EXE /Online /Cleanup-image /RestoreHealth? "DISM.exe /Online /Cleanup-Image /Restorehealth" is a DISM command that repairs issue with the...
DHCP Relay agent

DHCP Relay Agent: Configuration in Windows Server 2016

What is a DHCP Relay Agent? A DHCP Relay Agent allows DHCP clients in a different network subnet to...

TRENDING POSTS

Remote Desktop Connection

Remote Desktop Connection an Internal Error Has Occurred [Fixed]

Introduction I recently received the error message "Remote Desktop Connection an Internal Error Has Occurred". It was strange because...

Find My Samsung: Register and Use Samsung Find my Mobile

Introduction Ever wondered how you could find your Samsung phone if you lost it? Find my Samsung or Samsung...
What is the Difference Between PowerShell and CMD?

Windows Powershell vs CMD: Differences and Similarities

Introduction This short guide compares Windows PowerShell vs CMD (Windows command prompt). I will cover the history and nature...
Spotify No Longer Supports this Version of Microsoft Edge

Spotify No Longer Supports this Version of Microsoft Edge [Fixed]

Introduction When you open Spotify web player on Microsoft Edge, you may receive the error message "Spotify No Longer...
Windows 10 Won't Boot

Windows 10 Won’t Boot With Black Screen? 3 Ways to Fix It

Why Won't Windows 10 Boot Up? If your Windows 10 stops with a black screen, the first question in...

BEST OF ITECHGUIDES

dropbox login

Dropbox Login: Your Ultimate Guide to Dropbox

Introduction Dropbox login allows you to sign in to and use Dropbox. But what is Dropbox? Let's kick off...
Outlook 365: Subscription, Installation and Set Up

Outlook 365: Subscription, Installation and Set Up

If you are reading this you are probably one of the many people asking a lot of question about outlook 365 -...
Remote Desktop Connection

Remote Desktop Connection an Internal Error Has Occurred [Fixed]

Introduction I recently received the error message "Remote Desktop Connection an Internal Error Has Occurred". It was strange because...
turn on battery saver

7 Ways to Save Battery on Samsung Galaxy S9

Introduction Battery lifetime is arguably the biggest problem facing smartphone users today. This guide shows 7 ways to turn...

Powershell For Loop Explained: Syntax and Examples

Introduction "Powershell For Loop" (or Statement) is a construct that is used to run a command in a...

RECENT POSTS

disable cortana windows 10 featured

How to Disable Cortana in Windows 10 (2 Methods)

Introduction Some Windows 10 users may not like Cortana. Solution? Disable Cortana. You are probably reading this because you...
bootrec /fixboot access is denied

How to Fix BootRec /FixBoot Access is Denied Error in Windows 10

Introduction BootRec /FixBoot Access is Denied Error in Windows 10? This error is likely caused by corrupt EFI directory.
Reset Windows 10

How to Reset Windows 10 (2 Methods)

Introduction If your Windows 10 is broken, one available way to fix it is to use Windows 10 reset....
system restore windows 10

How to Enable and Use System Restore in Windows 10

Introduction System restore in windows 10 is a very important tool that is probably ignored by most users. But...
windows has stopped this device code 43

How to Fix Windows Has Stopped this Device Code 43 Error

Introduction Sometimes you may receive "Windows has stopped this device code 43" error. This error is likely to come...
Windows could not automatically detect this network's proxy settings

How to Fix “Windows Could not Automatically Detect this Network’s Proxy Settings”

Introduction You suddenly lose the ability to connect to the internet. Then you run network troubleshooter and it returns...
printer offline

5 Ways to Restore Your Printer Online If Status is Offline

Introduction Is your printer offline? Setting it online is very simple but sometimes it is more than just setting...

How to Fix “BootMgr is Missing” Error in Windows 10

Introduction If you receive Fix "BootMgr is missing" Error in Windows 10, the default response is panic! But you...
windows 10 search featured

How to Fix Windows 10 Search If it Stops Working

Introduction Are you having troubles with Windows 10 search? Apparently, it is a fairly common problem with a number...
oooops, something went wrong. reload

How to Fix “Oooops something went wrong. reload” Spotify Error

Introduction If you receive "Oooops something went wrong. reload" Spotify error, do not panic. The fix is simpler than...

MUST READ

Outlook 365: Subscription, Installation and Set Up

Outlook 365: Subscription, Installation and Set Up

If you are reading this you are probably one of the many people asking a lot of question about outlook 365 -...
this accessory may not be supported

This Accessory May Not be Supported [Fix]

What Does This Accessory May Not be Supported Mean? You may receive "this accessory may bot be supported" error...
spotify no longer supports this version of chrome

How to Fix “Spotify no Longer Supports this Version of Chrome”

Introduction Have you been frustrated by "Spotify no Longer Supports this Version of Chrome" error? You are not alone!...
windows system32 config systemprofile desktop is unav

How to Fix “C:WINDOWSsystem32configsystemprofileDesktop Is Unavailable” Error in Windows 10

Introduction You may receive the error message "WINDOWS system32 config systemprofile Desktop is unavailable" after upgrading to Windows 10....
How to Make a Line Graph in Excel and Google Sheets

How to Make a Line Graph in Excel

Introduction A line graph is a visual representation of a set of data. This guide shows you how to...

By using this website you agree to accept our Privacy Policy and Terms & Conditions