Create a Pivot Table Report in Google Docs Spreadsheets [New Feature]

If you are familiar with Microsoft Excel, you may use Pivot Table to quickly summarize large amounts of data. Now Google added this feature to Google Docs.

Let us see how to create a Pivot Table report in Google Docs.

First create a Spreadsheet in Google Docs; Create New->Spreadsheet and prepare a sample data as follows.

In this example I am going to summarize the data based on item description. Under Item description I have given different structural steel items (ISMC 100 & ISA 65x65x6) and you can see against each item the quantity in Metric Ton and the location of items used.

Now let us see how to summarize the above data using Pivot Table. Here I am going to summarize the steel items location wise.

1) First select entire data 2) Now go to Data->Pivot table report.

You can see Report Editor on the right side of the page. In order to create a report you need to add fields by click the add field against Rows, Columns, Values etc.

3) Here against Rows I have added Item Description, against Columns I have added location and against Values Quantity in MT.

See the report editor below

The Pivot Table Report will be looked like as seen below.

Items are summarized and the quantity of each items are shown location wise. See what will be the result if you omit add field against Columns.

The report will only show summary of items and total quantity.

In one of our earlier article we have informed our readers about the coming launch of Google Chromebooks. Chromebooks do not run traditional PC software because it is built and optimized for the web. Millions of web apps are the backbone of Chromebooks. So any added feature to online apps like Google docs will be a blessing for Chromebook users.