Pivot Tables now in Google spreadsheets
Tuesday, May 17, 2011
Over the past few months, we’ve released a string of new features in Google Docs to give your business more tools for collaborative document editing and data analysis. From simpler file uploads to discussions and mobile editing in documents, we’re making it easier for you and your colleagues to work together on the web. Continuing with this effort, we’re launching pivot tables in Google spreadsheets, which will be rolled out to all Rapid Release users over the next 24 hours.
With pivot tables, you can quickly narrow down large data sets to get high level insights. Say you run a retail chain and you have thousands of rows of sales data broken down by purchase. It could be helpful for you and your sales manager to view the total annual revenue for each region without having to enter multiple formulas. In a matter of seconds, you can create a pivot table and summarize all of your data according to the factors you specify, all while collaborating with your sales manager on the spreadsheet.
To see how pivot tables work in Google spreadsheets, check out this video:
We hope pivot tables in Google spreadsheets will help you save time analyzing your data. For more details on using pivot tables, take a look at our post on the Google Docs Blog.
Subscribe to:
Post Comments (Atom)
8 comments:
NICE - it is so easy to use... makes excel pivot tables look downright horrible to use...
-Dan
Yay!
Now if I could only figure out how to use them quickly & effectively. Brain-buster!
it is good tool
Thanks for adding pivot tables! Do you have an Excel v. GSpreadsheet pivot table feature comparison...it'd be helpful to see before stubbing my toe on a missing capability. Thanks!
Pivot Tables are *the best* tool in MS Excel, and now you have brought this fantastic feature to GDocs??
Now when will you offer a Google Docs Enterprise Appliance so that I can use this for work...
(A certain large US Aerospace company does not trust their data to Google's cloud)
I Have a feature request. Can you add a way to use a single field but "group" them in multiple ways?
i.e. I have a bunch of unique decimal numbers, I would like the rows to be say groupings rounded to the nearest decimal. Or for date - times, be able to group by day/month/year/hour.
I can work around this by making extra fields that are simply rounded versions of the main field - but the pivotTable should be able to do it automatically.
Google pivot tables are a great feature, but there doesn't seem to be a facility for adding the column headings in the source spreadsheet to the data in the pivot table. For example, my data has names of people categorized by age. I need the pivot table to show "Names of 5-11 year-olds", "Names of 12-18 year-olds" etc at the top of the columns, but it will not do this. It just lists the names in the columns, but there is no way of seeing the age category they come into because the header is missing. The heading is on the source spreadsheet, so why can't the pivot table pick this up? I gather this facility is within Excel 2010, so please can we have it in Google Spreadsheets too?
Post a Comment
Thank you for sharing your feedback with the Google Enterprise team. We will respond to open issues addressed in Comments with future posts on this blog. We appreciate your interest in Google Enterprise.