This week Google Docs introduced Pivot Tables in Google Spreadsheets. I am not that familiar to google spreadsheets but I had to try the new pivot table feature. I added some random data to a spreadsheet. I also created a new column Month to group values into months.

Formula in cell B2:

=Text(A2,"MMMM")

I then created the pivot table.

Added values

Pivot table

Months are sorted from A to Z. Adding a number in front of each month solves this issue.

Formula in cell B2:

=MONTH(A2)&" - "&Text(A2,"MMMM")

I changed a value in the table and the pivot table refreshes instantly. Great!

I added a new record but nothing happened to the pivot table. I googled dynamic named ranges and they seem impossible to create in Google spreadsheets right now.

Google docs have created a great new feature in Google Spreadsheets!

Related posts:

Quickly create links to sheets, tables, pivot tables and named ranges in a workbook

How to create a dynamic pivot table and refresh automatically in excel

Disable autofit column widths for all pivot tables in a sheet

Why use Pivot table and pivot chart?

Excel 2007 pivot table: Count unique distinct records (rows)