In This GURU G video we have discussed
1. How to make pivot table in google sheets
2. How to add multiple headers in row and column
3. How to use filter in pivot table
4. How to add subtotal
5. How to edit data range
Our Channel Link to share with your friends:
[ Ссылка ]
To get this Excel WorkBook or to get professional consultation, Please share your email id in comments or fill the google form by clicking the following link
[ Ссылка ]
Please like our Facebook Page:
[ Ссылка ]
Please send request on our FB Profile:
[ Ссылка ]
Please like our Instagram Page
[ Ссылка ]
Follow us on Quora :
Profile: [ Ссылка ]
General Discussion Space: [ Ссылка ]
Excel Space: [ Ссылка ]
Google Sheets Space: [ Ссылка ]
Please like our twitter: [ Ссылка ]
Please like our Tumblr page: [ Ссылка ]
Please share your suggestions and requirements in comments
For More Other Excel Videos please subscribe to the channel: [ Ссылка ]
Pivot tables help you summarize and analyze large data sets by displaying the information in more digestible formats. They make it much easier to take out small pieces of information and conclusions from a large set of information.
Add or edit pivot tables
On your computer, open a spreadsheet in Google Sheets.
Select the cells with source data you want to use. Important: Each column needs a header.
In the menu at the top, click Data and then Pivot table. Click the pivot table sheet, if it’s not already open.
In the side panel, next to "Rows" or "Columns," click Add, then choose a value.
Note: Sometimes, you'll see recommended pivot tables based on the data you choose. To add a pivot table, under "Suggested," choose a pivot table.
In the side panel, next to "Values," click Add, then choose the value you want to see over your rows or columns.
You can change how your data is listed, sorted, summarized, or filtered. Next to what you want to change, click the Down Arrow Down Arrow.
Change or Remove data:
On your computer, open a spreadsheet in Google Sheets.
Click the pivot table.
In the side panel, change or remove fields:
To move a field , drag it to another category.
To remove a field, click Remove Remove.
To change the range of data used for your pivot table, click Select data range Select data range.
Note: The pivot table refreshes any time you change the source data cells it’s drawn from.
Calculate a value with a custom formula
On your computer, open a spreadsheet in Google Sheets.
Click the pivot table.
In the side panel, next to "Values," click Add and then click Calculated field.
In the field that appears, enter a formula. Then, next to "Summarize by," click Custom.
You can use other columns to write a formula. For example, you can use =sum(Price)/counta(Product) where "Price" and "Product" are fields in the pivot table.
You can use Google Sheets functions in your formula.
You'll see a new column called "Calculated field 1."
![](https://s2.save4k.ru/pic/FxcToXZimCI/maxresdefault.jpg)