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

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
  • 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

  • Was this post Helpful?
  • YesNo

LEAVE A REPLY

Please enter your comment!
Please enter your name here

ADVERTISEMENTS

FEATURED POSTS

Best Christian Movies on Netflix

The 10 Best Christian Movies on Netflix

This Itechguide reviews the 10 best christian movies on Netflix. The movies are listed in reverse order – with the 10th movie...
How to Change Orientation in Google Docs

How to Change Orientation in Google Docs

This Itechguide teaches you how to change orientation in Google Docs. The guide covers steps to change orientation in Google Docs from...
How to Delete Google Photos

How to Delete Google Photos

This Itechguide teaches you how to delete Google Photos. The guide offers steps to delete Google Photos from the Google Photos App...
How to Install Windows 10 1909 Update Manually

How to Install Windows 10 1909 Update Manually

This Itechguide teaches you how to install Windows 10 1909 update manually. Windows 10 1909 (otherwise known as Windows 10 November update)...
How to Create a Poll on Facebook

How to Create a Poll on Facebook

This Itechguide teaches you how to create a poll on Facebook. You can create a poll on Facebook from a Facebook page...

AMAZON DEALS

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...

ADVERTISEMENTS

BEST OF ITECHGUIDES

Configure Group Policy for Windows Updates Server 2016 (WSUS Server 2016)

How to Configure Group Policy for WSUS in Windows Server 2016

Introduction This guide demos how to configure Group Policy for Windows Updates Server 2016 (WSUS Server 2016).
How to see Followers on Facebook

How to see Followers on Facebook

This Itechguide teaches you how to see followers on Facebook. The guide covers steps to see followers on Facebook App or a...

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...
WhatsApp Web QR Code Not Working

WhatsApp Web QR Code Not Working? Here is the Fix

If WhatsApp Web QR code is not working. That is, the QR codes is not getting scanned it may be caused by...
the-user-profile-service-failed-the-logon-featured

How to Fix “The User Profile Service Failed the Logon” in Windows 10

Introduction "The user profile service failed the logon Windows" error is likely to occur after an upgrade to Windows...

RECENT POSTS

How to Change Facebook Page Name

How to Change Facebook Page Name

This Itechguide teaches you how to change Facebook page name. The guide covers steps to change Facebook page name from a PC...
How to Change YouTube Channel Name

How to Change YouTube Channel Name

This Itechguide teaches you how to change YouTube channel name. The guide covers steps to change YouTube channel name from a PC.
How to Bold Text on Facebook Post

How to Bold Text on Facebook Post

This Itechguide teaches you how to bold text on Facebook post. The guide covers steps to bold text on Facebook post from...
Best Crime Documentaries on Netflix

The 10 Best Crime Documentaries on Netflix

This Itechguide reviews the 10 best crime documentaries on Netflix. The documentaries are listed in reverse order – with the 10th documentary...
Best Netflix Series

The 10 Best Netflix Series

This Itechguide reviews the 10 best Netflix series. The series are listed in reverse order – with the 10th series on top....

AMAZON DEALS

MUST READ

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...
How-to-Make-a-Facebook-Post-Shareable

How to Make a Facebook Post Shareable

Introduction This guide demonstrates how to make a Facebook post shareable. You can make a new or an existing...
join windows insider program

How to Join Windows 10 Insider Program

Introduction When you join Windows Insider Program, you have the opportunity "to help shape the next evolution of Windows...
mobile hotspot greyed out windows 10

Mobile Hotspot Greyed Out on Windows 10, iPhone or Android [Fixed]

Introduction If mobile hotspot is greyed out on windows 10, iPhone or Android it is likely that you do...
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...

AMAZON DEALS

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