Analysis the data with Pivot Table in Google Sheet

Pivot table is the most commonly used function to do analysis data in sheets.

You can create a pivot table easily in google sheet with the data menu pivot commend.  Refer the picture.

 

 

The google sheet will create the pivot table in a new sheet; just select the required field in the right column of the pivot table.

Very simple steps with an added feature of sorting the value in pivot table in the options.

 

I have created a data sheet with a sample pivot table for you to understand it and work on the sheet to get practice of pivot table function.

 

In the sample data; I have also used a date and text function to fine the month representing the transactions.  You can use the function to create a meaning full pivot and reports can be generated easily.   Please give your feedback after using the sample data in the following data.

 

https://docs.google.com/spreadsheets/d/1dD8XmC8FKvxL2UTKM6maWuwaivyDmP-f5D4fFdfciYs/edit?usp=sharing